SE_table_get_grantee_privilege_list

Returns a list of the permissions on a table for a specific user

Usage syntax

LONG SDEAPI SE_table_get_grantee_privilege_list (SE_CONNECTION handle,
ACHAR *table_name,
LONG  *num_grantees,
LONG  **privileges,
ACHAR ***grantees)

Parameters
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)
Description

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.

Returns

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