Defining user privileges

Privileges are the set of actions that a user can perform. The SQL GRANT and REVOKE statements assign privileges.

You can use the Classic Data Architect to grant and revoke one or more of the following privileges:
  • System
  • Database
  • Stored procedures
  • Tables and views

The GRANT and REVOKE are executable statements that can be dynamically prepared.

A specific grantor can grant or revoke specific privileges to specific users, with the restriction that a privilege can only be revoked if it has first been granted.