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.
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 the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.