ipDCL

You must implement this method in your IP if it is to handle the SQL database control language (DCL) syntax for managing user privileges. This means that the OpenAccess SDK SQL Engine calls this method anytime it needs to manipulate a system or object privilege (for example, GRANT CREATE TABLE TO JOHN) or it needs to delete a privilege (for example, REVOKE DROP ANY INDEX FROM JOHN). The ipGetSupport method should return true for the supported DCL operations.

Refer to "Implementing DCL Support" in Chapter 4 of OpenAccess SDK SQL Engine Programmer’s Guide for more information.

Table 3: Parameters for ipDCL
Parameter	Type	Description
IN
hstmt	int64	Statement handle of the currently active statement
iType	int	Type of command requested DAM_CREATE_USER – create an user DAM_DROP_USER – drop an user DAM_CREATE_ROLE – create a role DAM_DROP_ROLE – drop a role DAM_GRANT – grant a privilege DAM_REVOKE – revoke a privilege
OUT
piNumResRows	long	The number of rows affected by this operation
RETURN
	int	DAM_SUCCESS – on success DAM_FAILURE – on failure

ipDCL

See also