System Privileges
A system privilege is the right to perform a particular action or to perform an action on any object of a particular type. Objects include tables, views, materialized views, synonyms, indexes, sequences, cache groups, replication schemes and PL/SQL functions, procedures and packages. Only the instance administrator or a user with ADMIN
privilege can grant or revoke system privileges.
Table 7-1 System privileges
Privilege | Description |
---|---|
|
Enables a user to perform administrative tasks including checkpointing, backups, migration, and user creation and deletion. |
|
Enables a user to alter any cache group in the database. |
|
Enables a user to alter any index in the database. Note: There is no |
|
Enables a user to alter any materialized view in the database. Note: There is no |
|
Enables a user to alter any PL/SQL procedure, function or package in the database. |
|
Enables a user to alter any sequence in the database. |
|
Enables a user to alter any table in the database. |
|
Enables a user to alter any view in the database. Note: There is no |
|
Enables a user to perform operations related to cache groups. |
|
Enables a user to create a cache group owned by any user in the database. |
|
Enables a user to create an index on any table or materialized view in the database. |
|
Enables a user to create a materialized view owned by any user in the database. |
|
Enables a user to create a PL/SQL procedure, function or package owned by any user in the database. |
|
Enables a user to create a sequence owned by any user in the database. |
|
Enables a user to create a private synonym owned by any user in the database. |
|
Enables a user to create a table owned by any user in the database. |
|
Enables a user to create a view owned by any user in the database. |
|
Enables a user to create a cache group owned by that user. |
|
Enables a user to create a materialized view owned by that user. |
|
Enables a user to create a PL/SQL procedure, function or package owned by that user. |
|
Enables a user to create a public synonym. |
|
Enables a user to create a sequence owned by that user. |
|
Enables a user to create a connection to the database. |
|
Enables a user to create a private synonym. |
|
Enables a user to create a table owned by that user. |
|
Enables a user to create a view owned by that user. |
|
Enables a user to delete from any table in the database. |
|
Enables a user to drop any cache group in the database. |
|
Enables a user to drop any index in the database. |
|
Enables a user to drop any materialized view in the database. |
|
Enables a user to drop any PL/SQL procedure, function or package in the database. |
|
Enables a user to drop any sequence in the database. |
|
Enables a user to drop a synonym owned by any user in the database. |
|
Enables a user to drop any table in the database. |
|
Enables a user to drop any view in the database. |
|
Enables a user to drop a public synonym. |
|
Enables a user to execute any PL/SQL procedure, function or package in the database. |
|
Enables a user to flush any cache group in the database. |
|
Enables a user to insert into any table in the database. It also enables the user to insert into any table using the synonym, public or private, to that table. |
|
Enables a user to load any cache group in the database. |
|
Enables a user to flush any cache group in the database. |
|
Enables a user to select from any sequence or synonym on a sequence in the database. |
|
Enables a user to select from any table, view, materialized view, or synonym in the database. |
|
Enables a user to unload any cache group in the database. |
|
Enables a user to update any table or synonym in the database. |
|
Enables a user to connect to a database as an XLA reader. |