Powered by Zoomin Software. For more details please contactZoomin

DataDirect OpenAccess SDK Help

Object privileges

  • Last Updated: May 12, 2026
  • 1 minute read
    • OpenAccess SDK
    • Version 8.1
    • Documentation

Each type of object has different privileges associated with it. The Xs in the following table indicate the object and privilege combinations that OpenAccess SDK supports.

Object privileges

Privilege name Table View Procedure
ALTER X    
DELETE X  
EXECUTE   X
INDEX X    
INSERT X    
SELECT X X  
UPDATE X    

Command syntax

GRANT {object_priv | ALL [PRIVILEGES],...} ON {[qualifier].[owner].object}
TO {user | role | PUBLIC,...}
REVOKE {object_priv | ALL [PRIVILEGES],...} ON {[qualifier].[owner].object}
FROM {user | role | PUBLIC,...} 

Calls to dam_getFirstView() and dam_getNextView() allow the IP to iterate through the list of views. The IP can use this information while implementing the DCL commands GRANT and REVOKE.

The dam_getFirstView() and dam_getNextView() calls return all existing view definitions and not filter based on current qualifier.

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