skip to main content
Designing and coding the IP : Privileges : Object privileges
 

Object privileges

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.
 
Table 18: 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.