| SE_table_grant_access | |
Grants a user access to a given table.
LONG SE_table_grant_access
(SE_CONNECTION connection,
const CHAR *table,
LONG privilege,
BOOL grant,
const CHAR *user);
| connection | The connection handle |
| table | A pointer to a table name |
| privilege | Pointer to a permission bit-mask |
| grant | TRUE to allow the new user to grant rights |
| user | The DBMS user name |
SE_table_grant_access gives a user access to a given table. The table name is in the format <owner>.<table>. If <owner> is omitted, ArcSDE assumes that the current user is the owner. Privileges are:
SE_SELECT_PRIVILEGE
SE_UPDATE_PRIVILEGE
SE_INSERT_PRIVILEGE
SE_DELETE_PRIVILEGE
You can grant multiple privileges by ORing the bitmasks. Set grant to TRUE if the specified user can grant and revoke privileges to other users.
SE_SUCCESS
SE_DB_IO_ERROR
SE_INVALID_POINTER
SE_INVALID_USER
SE_NET_FAILURE
SE_NO_PERMISSIONS
SE_SDE_NOT_STARTED
SE_TABLE_NOEXIST
• The user must have appropriate DBMS privileges to grant access to a table.