J.4. Group or User.SetPermissions Method Options
The SetPermssions method of both the Group and User objects allows you to specify the permissions a group or user has to a database object.
J.4.1. ObjectType Values
The ObjectType option specifies the type of object to which the permission will be applied.
| Constant | Value | Description |
|---|---|---|
| AdPermObjColumn | 2 | The object is a column. |
| AdPermObjDatabase | 3 | The object is a database. |
| adPermObjProcedure | 4 | The object is a procedure. |
| adPermObjProviderSpecific | −1 | The object type is defined by the provider. If you specify this value, you must also supply an ObjectTypeID |
| AdPermObjTable | 1 | The object is a table. |
| AdPermObjView | 5 | The object is a view. |
J.4.2. Action Values
The Action option specifies what you intend to do with the permission to the specified object.
| Constant | Value | Description |
|---|---|---|
| adAccessDeny | 3 | Deny the specified permissions. |
| adAccessGrant | 1 | Grant the specified permissions. The permissions specified are added to those that have already been granted. |
| adAccessRevoke | 4 | Revoke all permissions. |
| adAccessSet | 2 | Set the specified permissions. Only the specified permissions will be in force. |
J.4.3. Rights Values
The Rights option specifies the actual rights, or permissions, that you are denying, granting, revoking, or setting.
| Constant | Value | Description |
|---|---|---|
| AdRightCreate | 16384 | The user/group has permission to create a new object of the specified type. |
| AdRightDelete | 65536 | The user/group has permission to delete data from the specified object. For objects such as tables, the user also has permission ... |
Get Access 2003 VBA Programmer's Reference now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
