| SE_table_revoke_access | |
Removes a user's privileges to a given table.
LONG SE_table_revoke_access
(SE_CONNECTION connection,
const CHAR *table,
LONG privilege,
const CHAR *user);
| connection | The connection handle |
| table | A pointer to a table name |
| privilege | Pointer to a permission bit-mask |
| user | The DBMS user name |
SE_table_revoke_access removes a user's 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 revoke multiple privileges by ORing the bitmasks.
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 remove access to a table.