Powered by Zoomin Software. For more details please contactZoomin

DataDirect OpenAccess SDK Help

OAIP_privilege and OAIP_privilegeW

  • Last Updated: May 12, 2026
  • 2 minute read
    • OpenAccess SDK
    • Version 9.0
    • Documentation

One of these functions must be implemented by the IP, if the IP is to support privileges. This function is called before the SQL engine processes any commands. It is passed in the user name, the operation code, and the fully qualified object name. The function should return TRUE if the specified user is allowed to perform the requested operation on the object.

The GETSUPPORT function should return true for IP_SUPPORT_PRIVILEGE.

Refer to Implementing Privilege Support in the OpenAccess SDK Programmer's Guide for more information.

OAIP_privilege (8-bit character version)

int OAIP_privilege(
    IP_HDBC ip_hdbc,
    int     iCmdType,
    char *  pcUserName,
    char *  pcQualifier,
    char *  pcOwner,
    char *  pcName)

Parameters for OAIP_privilege (8-bit Character Version)

Parameter Type Description
IN
ip_hdbc IP_HDBC The connection handle as defined by the IP.
iCmdType int The type of DCL operation.
pcUserName char * The name of the connected user.
pcQualifier char * The name of the database in which the table falls. This parameter can be used to distribute tables into physically different databases.
pcOwner char * The owner of this object.
pcName char * The name of this object.
RETURN
int DAM_TRUE - the SQL engine can perform the requested operation.
DAM_FALSE - the operation is not authorized.

OAIP_privilegeW (Unicode version)

int OAIP_privilegeW(
    IP_HDBC   ip_hdbc,
    int       iCmdType,
    OAWCHAR * pcUserName,
    OAWCHAR * pcQualifier,
    OAWCHAR * pcOwner,
    OAWCHAR * pcName)

Parameters for OAIP_privilegeW (Unicode Version)

Parameter Type Description
IN
ip_hdbc IP_HDBC The connection handle as defined by the IP.
iCmdType int The type of DCL operation.
pcUserName OAWCHAR * The name of the connected user.
pcQualifier OAWCHAR * The name of the database in which the table falls. This parameter can be used to distribute tables into physically different databases.
pcOwner OAWCHAR * The owner of this object.
pcName OAWCHAR * 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 the OAIP_privilege or OAIP_privilegeW function, 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.

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