Permissions

A long value Establishes permissions for User or Group given by the UserName property

For a Container object other than Tables and Databases containers, any of the following constants are available

Constant

The User

dbSecNoAccess

Does not have access to the object (not valid for Document objects).

dbSecFullAccess

Has full access to the object.

dbSecDelete

Can delete the object.

dbSecReadSec

Can read the object's security-related information.

dbSecWriteSec

Can alter access permissions.

dbSecWriteOwner

Can change the Owner property setting

For a Container object for the Tables container, any of the following constants are available

Constant

The User Can

dbSecCreate

Create new documents (not valid for Document objects).

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.

For a Container object for the Databases container, any of the following constants are available

Constant

The User

dbSecDBAdmin

Can replicate a database and change the database password (not valid for Document objects).

dbSecDBCreate

Can create new databases. This option is valid only on the Databases container in the workgroup information file (Systen.mdw). This constant isn't valid for Document objects.

dbSecDBExclusive

Has exclusive access to the database.

dbSecDBOpen

Can open the database