Powered by Zoomin Software. For more details please contactZoomin

DataDirect OpenAccess SDK Help

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

See also

TitleResults for “How to create a CRG?”Also Available inAlert