SE_table_get_grantee_privilege_list |
Returns a list of the permissions on a table for a specific user
LONG SDEAPI SE_table_get_grantee_privilege_list (SE_CONNECTION
handle,
ACHAR *table_name,
LONG *num_grantees,
LONG **privileges,
ACHAR ***grantees)
handle | The ArcSDE connection handle (input) |
table_name |
A qualified object name (<owner_name>.<table_name>) The API parses the qualified object name input to obtain the DBMS-specific qualifiers by calling SE_table_parse_qualifiednameW() and formulates the privilege query appropriate to the DBMS. (input) |
num_grantees | The number of distinct users who have been granted SELECT, INSERT, UPDATE, and/or DELETE privileges on table_name (output) |
privileges | An array of SE_Privilege bitmasks allocated based on the num_grantees; obtained by querying the DBMS data dictionary (output) |
grantees | An array of distinct user names allocated based on num_grantees; obtained by querying the DBMS data dictionary (output) |
SE_table_get_grantee_privilege_list returns a list of users and their permissions on a given table. Permissions are returned as bitmasks, but equate to the following:
SE_SELECT_PRIVILEGE
SE_UPDATE_PRIVILEGE
SE_INSERT_PRIVILEGE
SE_DELETE_PRIVILEGE
Returned permissions could be multiple.
The table name is in the format <owner>.<table>. If <owner> is omitted, ArcSDE assumes that the current user is the owner.
When the list of grantees and privileges are no longer needed, free the memory allocated using SE_table_free_grantee_list and SE-table_free_privilege_list.
SE_SUCCESS
SE_CONNECTION_IN_USE
SE_CONNECTION_LOCKED
SE_DB_IO_ERROR
SE_INVALID_CONNECTION
SE_INVALID_PARAM_VALUE
SE_INVALID_POINTER
SE_NET_FAILURE
SE_SDE_NOT_STARTED
SE_TABLE_NOEXIST