ipDCL
- Last Updated: May 12, 2026
- 1 minute read
- OpenAccess SDK
- Version 8.1
- Documentation
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 the OpenAccess SDK SQL Engine Programmer’s Guide for more information.
int ipDCL(
int64 hstmt,
int iType,
out long piNumResRows)
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 |