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.