Privilege basics
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