Oracle Database Administration: The Essential Refe

Privileges That Allow You to Manipulate Objects in Any Schema

Table 15.4 lists the privileges that allow you to manipulate all other users’ objects. If you have these privileges, you will not need to be granted object privileges on the objects themselves. The privileges in this category are intended to be used primarily by DBAs and support personnel and have been granted to the DBA role.

Table 15-5. Privileges That Allow You to Manipulate Objects in Any Schema

ALTER ANY CLUSTER	ALTER ANY INDEX
ALTER ANY LIBRARY	ALTER ANY PROCEDURE
ALTER ANY ROLE	ALTER ANY SEQUENCE
ALTER ANY SNAPSHOT	ALTER ANY TABLE
ALTER ANY TRIGGER	ALTER ANY TYPE
ANALYZE ANY	AUDIT ANY
BACKUP ANY TABLE	COMMENT ANY TABLE
CREATE ANY CLUSTER	CREATE ANY DIRECTORY
CREATE ANY INDEX	CREATE ANY LIBRARY
CREATE ANY PROCEDURE	CREATE ANY SEQUENCE
CREATE ANY SNAPSHOT	CREATE ANY SYNONYM
CREATE ANY TABLE	CREATE ANY TRIGGER
CREATE ANY TYPE	CREATE ANY VIEW
DELETE ANY TABLE	DROP ANY CLUSTER
DROP ANY DIRECTORY	DROP ANY INDEX
DROP ANY LIBRARY	DROP ANY PROCEDURE
DROP ANY ROLE	DROP ANY SEQUENCE
DROP ANY SNAPSHOT	DROP ANY SYNONYM
DROP ANY TABLE	DROP ANY TRIGGER
DROP ANY TYPE	DROP ANY VIEW
EXECUTE ANY LIBRARY	EXECUTE ANY PROCEDURE
EXECUTE ANY TYPE	FORCE ANY TRANSACTION
INSERT ANY TABLE	LOCK ANY TABLE
SELECT ANY SEQUENCE	SELECT ANY TABLE
UPDATE ANY TABLE