DataDirect OpenAccess SDK Help

dam_getNextPrivilege

Save PDF

Save PDF

This method is used to navigate the privilege list in the GRANT and REVOKE commands. It is used in the ipDCL method.

int dam_getNextPrivilege(
int64 hstmt,
out int piPrivilegeId,
StringBuilder szCatalog,
StringBuilder szRoleName)

Parameters for dam_getNextPrivilege

Parameter	Type	Description
IN
hstmt	int64	The statement handle
OUT
piPrivilegeId	int	Type of the Privilege: 0 – indicates that the privilege is a Role System Privilege Object Privilege SQL_SYS_PRIV_CREATE_ANY_INDEX SQL_SYS_PRIV_ALTER_ANY_INDEX SQL_SYS_PRIV_DROP_ANY_INDEX SQL_SYS_PRIV_GRANT_ANY_PRIVILEGE SQL_SYS_PRIV_CREATE_PROCEDURE SQL_SYS_PRIV_CREATE_ANY_PROCEDURE SQL_SYS_PRIV_DROP_ANY_PROCEDURE SQL_SYS_PRIV_EXECUTE_ANY_PROCEDURE SQL_SYS_PRIV_GRANT_ANY_ROLE SQL_SYS_PRIV_CREATE_TABLE SQL_SYS_PRIV_CREATE_ANY_TABLE SQL_SYS_PRIV_ALTER_ANY_TABLE SQL_SYS_PRIV_DROP_ANY_TABLE SQL_SYS_PRIV_SELECT_ANY_TABLE SQL_SYS_PRIV_INSERT_ANY_TABLE SQL_SYS_PRIV_UPDATE_ANY_TABLE
piPrivilegeId (cont’d)		System Privileges: SQL_SYS_PRIV_DELETE_ANY_TABLE SQL_SYS_PRIV_CREATE_VIEW SQL_SYS_PRIV_CREATE_ANY_VIEW SQL_SYS_PRIV_DROP_ANY_VIEW SQL_SYS_PRIV_CREATE_USER SQL_SYS_PRIV_CREATE_ANY_USER SQL_SYS_PRIV_DROP_ANY_USER SQL_SYS_PRIV_CREATE_ROLE SQL_SYS_PRIV_CREATE_ANY_ROLE SQL_SYS_PRIV_DROP_ANY_ROLE SQL_OBJ_PRIV_ALTER SQL_OBJ_PRIV_DELETE SQL_OBJ_PRIV_EXECUTE Object Privileges: SQL_OBJ_PRIV_INDEX SQL_OBJ_PRIV_INSERT SQL_OBJ_PRIV_SELECT SQL_OBJ_PRIV_UPDATE
szCatalog	StringBuilder	The name of the Catalog. Applicable if Privilege Id is returned as 0.
szRoleName	StringBuilder	The name of the role.
RETURN
	int	DAM_SUCCESS – on success DAM_FAILURE – on failure DAM_NO_DATA_FOUND – on end of list