Oracle Database Administration: The Essential Refe

Summary of System Privileges

This section contains a brief summary of all of Oracle’s system privileges, listed in alphabetical order. Some system privileges are new in Oracle8; this is noted in the list. A complete list of new Oracle8 system privileges can also be found later in this chapter.

ALTER ANY CLUSTER

Allows you to execute the ALTER CLUSTER command for all clusters in the database.

ALTER ANY INDEX

Allows you to execute the ALTER INDEX command for all indexes in the database.

ALTER ANY LIBRARY (Oracle8)

Allows you to execute the CREATE OR REPLACE LIBRARY command to alter an existing external library in another schema.

ALTER ANY PROCEDURE

Allows you to execute the ALTER FUNCTION, ALTER PACKAGE, and ALTER PROCEDURE commands to recompile any function, package, or procedure in the database. Also allows you to execute the CREATE OR REPLACE FUNCTION, CREATE OR REPLACE PACKAGE, and CREATE OR REPLACE PROCEDURE commands on any existing function, package, or procedure in the database.

ALTER ANY ROLE

Allows you to execute the ALTER ROLE command to add, change, or remove a password on the role.

ALTER ANY SEQUENCE

Allows you to execute the ALTER SEQUENCE command on any sequence in the database.

ALTER ANY SNAPSHOT

Allows you to execute the ALTER SNAPSHOT command on any snapshot in the database.

ALTER ANY TABLE

Allows you to execute the ALTER TABLE command on any table in the database. You must have the ALTER ANY TRIGGER privilege to execute the ALTER TABLE ... ENABLE/DISABLE ALL TRIGGERS command on ...