Returns all the permissions that apply to the current UserName property of the Container or Document object, including permissions that are specific to the user as well as the permissions a user inherits from memberships in groups (Microsoft Jet workspaces only).
Return Values
For any Container or Document object, the return value is a Long value or constant(s) that may include the following.
Constant | Description |
dbSecReadDef | The user can read the table definition, including column and index information. |
dbSecWriteDef | The user can modify or delete the table definition, including column and index information. |
dbSecRetrieveData | The user can retrieve data from the Document object. |
dbSecInsertData | The user can add records. |
dbSecReplaceData | The user can modify records. |
dbSecDeleteData | The user can delete records. |
In addition, the Databases container or any Document object in a Documents collection may include the following.
Constant | Description |
dbSecDeleteData | The user can delete records. |
dbSecDBAdmin | The user can replicate the database and change the database password. |
dbSecDBCreate | The user can create new databases. This setting is valid only on the Databases container in the workgroup information file (System.mdw). |
dbSecDBExclusive | The user has exclusive access to the database. |
dbSecDBOpen | The user can open the database. |
Remarks
This property contrasts with the Permissions property, which returns only the permissions that are specific to the user and doesn't include any permissions that the user may also have as a member of groups. If the current value of the UserName property is a group, then the AllPermissions property returns the same values as the Permissions property.