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 |