DataDirect OpenAccess SDK Help

dam_getFirstPrivilege

Save PDF

Save PDF

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

Refer to the Privileges section in the OpenAccess SDK Programmer's Guide for details on implementing this method.

int dam_getFirstPrivilege(
    long         hstmt,
    xo_int       piPrivilegeId, 
    StringBuffer szCatalog,
    StringBuffer szRoleName)

Parameters for dam_getFirstPrivilege

Parameter	Type	Description
INPUT
hstmt	long	The statement handle.
piPrivilegeId	xo_int	The type of the Privilege: 0 - indicates that the privilege is a Role. System Privilege. Object Privilege. System Privileges: 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 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
		Object Privileges: SQL_OBJ_PRIV_ALTER SQL_OBJ_PRIV_DELETE SQL_OBJ_PRIV_EXECUTE SQL_OBJ_PRIV_INDEX SQL_OBJ_PRIV_INSERT SQL_OBJ_PRIV_SELECT SQL_OBJ_PRIV_UPDATE
szCatalog	StringBuffer	The name of the Catalog. Applicable if Privilege Id is returned as 0.
szRoleName	StringBuffer	The name of the role.
RETURN
	int	DAM_SUCCESS - on success DAM_FAILURE - on failure DAM_NO_DATA_FOUND - on end of list