There are two types of privileges—those granted on databases and those granted on tables, views, and procedures.

Privileges for databases are:

  • Granting or restricting system administration privileges (DBA)
  • Granting audit privileges (audit administration, audit archive, or audit application insert)
  • Granting or restricting general creation privileges on a database (RESOURCE)

Privileges granted on tables, views, and procedures grant or restrict operations on specific operations, such as:

  • Altering an object definition
  • Deleting, inserting, selecting and updating records
  • Executing stored procedures
  • Granting privileges
  • Defining constraints to an existing table