ipPrivilege
- 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 support privileges. This method is called before the OpenAccess SDK SQL Engine processes any commands. It passes in the user name, the operation code, and the fully qualified object name. Your method should return TRUE if the specified user is allowed to perform the requested operation on the object. ipGetSupport should return true for IP_SUPPORT_PRIVILEGE.
Refer to Implementing Privilege Support in the OpenAccess SDK SQL Engine Programmer’s Guide for more information.
int ipPrivilege(
int iCmdType,
string pcUserName,
string pcQualifier,
string pcOwner,
string pcName )
Parameters for ipPrivilege
| Parameter | Type | Description |
| IN | ||
| iCmdType | int | Type of DCL operation |
| pcUserName | string | Name of the connected user |
| pcQualifier | string | Name of the database in which the table falls. Can be used to distribute tables into physically different databases |
| pcOwner | string | The owner of this object |
| pcName | string | The name of this object |
| RETURN | ||
| int | DAM_TRUE – the SQL engine can perform the requested operation. DAM_FALSE – the operation is not authorized. |
When calling ipPrivilege, the OpenAccess SDK SQL Engine passes the full object information (qualifier.owner.name) for the following commands:
- CREATE TABLE
- ALTER TABLE
- DROP TABLE
- CREATE VIEW
- DROP VIEW