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

 

Get Oracle Database Administration: The Essential Refe now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.