skip to main content
Interface Provider class : IP methods reference : ipPrivilege
 

ipPrivilege

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 Chapter 4 of OpenAccess SDK SQL Engine Programmer’s Guide for more information.
int ipPrivilege(
int iCmdType,
string pcUserName,
string pcQualifier,
string pcOwner,
string pcName )
 
 
Table 25: 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 

• ipGetSupport