Privileges by object

A privilege applies only to the object for which it was granted. For example, when you grant a user the Drop privilege for a database, that privilege does not apply to any of the objects within that database, but only to the database itself.

The following table describes the list of privileges by object.
Table 1. Privileges by object
Object Privilege Description
Aggregate Alter Change the name or ownership of a UDA.
Drop Drop a UDA.
Execute Execute a UDA in a query.
List List UDAs.
Database Alter Change the name of a database.
Drop Drop a database.
List Connect to and display a database.
Function Alter Change the name or ownership of a function.
Drop Drop a function.
Execute Execute a function in a query.
List List functions.
Group Abort Abort a session.
Alter Change the name of a group.
Drop Drop a group.
List List groups.
Procedure Alter Change the name or ownership of a stored procedure.
Drop Drop a procedure.
Execute Execute a procedure in a query.
List List procedures.
Schema Alter Change the name or ownership of a schema.
Drop Drop a schema.
List List schemas.
System table Delete Delete rows from a system table.
Insert Insert rows into a system table.
List View a system table.
Select Select rows in a system table.
Update Update rows from the system table.
Sequence Alter Alter a sequence.
Drop Drop a sequence.
List List a sequence.
Select Select a sequence.
Update Use next value of a sequence.
System view List See a system view.
Select Select rows in a system view.
Synonym Alter Alter a synonym.
Delete Delete rows (if the synonym represents a table).
Drop Drop a synonym.
Insert Insert rows (if the synonym represents a table).
List List a synonym.
Select Select a synonym.
Update Update rows (if the synonym represents a table).
Table or external table Alter Change the name of a table.
Delete Delete rows from a table.
Drop Drop a table.
GenStats Generate statistics for the table.
Insert Insert rows into a table.
List View a table.
Select Select rows in a table.
Truncate Delete all rows from a table.
Update Update rows from the table.
User Abort Abort a session or a transaction.
Alter Change the name of a user.
Drop Drop a user.
List Display a user.
View or materialized view Alter Alter a view.
Drop Drop a view.
List See a view.
Select Select rows in a view.