AllPermissions

A long value that represent all permissions that apply for the current UserName

The AllPermissions property may include the following:

Constant

The User Can

dbSecReadDef

Read the table definition, including column and index information.

dbSecWriteDef

Modify or delete the table definition, including column and index information.

dbSecRetrieveData

Retrieve data from the Document object.

dbSecInsertData

Add records.

dbSecReplaceData

Modify records.

dbSecDeleteData

Delete records

dbSecDeleteData

Can delete records.

dbSecDBAdmin

Can replicate the database and change the database password.

dbSecDBCreate

Can create new databases. This setting is valid only on the Databases container in the workgroup information file (System.mdw).

dbSecDBExclusive

Has exclusive access to the database.

dbSecDBOpen

Can open the database

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