---

Qare Internals     SQL Tables         Account         appData         appTable         Applications         Inbox         KeyPair         localPrivileges         message         pendingMessage         privilege         project         registerInfo         RegisterPending         remoteAccount         session         System         user         userDelegations     Schema     Plugins     API  Site Map

localPrivileges Table The heart of QARE's delegation trust model is this table. This is a table of all the access permissions that have been delegated on a given system. The local permissions table has one row for each delegated access permission and several columns. Each privilege applies only to a single system. That system itself maintains the list of privileges, and the process of granting and rescinding them.

QareApplications         AppDir         ChangePassword         Count         CreateAccount         Delegation         DelegationDisplay         DeleteRemote         HelloWorld         Inbox         Login         Logout         Pending         Ping         Register         RemoteAccount         UserGroups

---

FIELD	TYPE	DESCRIPTION
applicationId	int(10) unsigned(PRI)	The application identifier for which the privileges has been assigned (linked with the application table).
privilegeId	int(10) unsigned(PRI)	The privilege identifier linked to the privilege table.
parentId	int(11) (PRI)	The parent identifier (user by whom this privilege was given,links to the user table)
grantorId	int(10) unsigned(PRI)	The grantor identifier(This is the person who granted the permission to the delegee ,links to the user table)
delegeeId	int(10) unsigned(PRI)	The delegee identifier( This is the person who has received a permission,links to the user table)
projectId	int(11) (PRI)	The project identifier(The name of the project for which the permission has been granted,links to te project table)
localPrivilegeId	int(11) (UNI) (auto_increment)	The row identifier
aquisitionDate	datetime	The date when the permission was granted.
delegationLimit	int(11)	The total number of times the delegee can grant this permission, directly or indirectly. The minimum value of this field is 1, as the delegee is also included in the count.
delegationCount	int(11)	The total number of delegations made to-date by the delegee. (Initial value is 1.) Example: when the delegee grants to another user a permision with a delegation limit of 3, then the delegee's count is increased by 3. But the delegation count must not exceed the delegation limit.
delegationDepth	int(11)	With 0 delegation depth the delegee can not further delegate the permission. A depth of 1 implies that the permission can be directly delegated to any number of delegees, but can not then be subsequently delegated. A depth of -1 places no constraint on delegation depth.