Table 15.10 shows the system privileges assigned to the initial users. Note that since the SYS and SYSTEM users are granted the DBA role by default, they actually acquire all the privileges granted through that role.
Granted to | ||||||
Privilege Assigned |
CTXSYS |
DBSNMP |
MDSYS |
ORDSYS |
SYS |
SYSTEM |
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 |
|
| ||||
ALTER DATABASE |
|
| ||||
ALTER PROFILE |
|
| ||||
ALTER RESOURCE COST |
|
| ||||
ALTER ROLLBACK SEGMENT |
|
| ||||
ALTER SESSION |
|
| ||||
ALTER SYSTEM |
|
| ||||
ALTER TABLESPACE |
|
| ||||
ALTER USER |
|
| ||||
ANALYZE ANY |
|
| ||||
AUDIT ANY |
|
| ||||
AUDIT SYSTEM |
|
| ||||
BACKUP ANY TABLE |
|
| ||||
BECOME USER |
|
| ||||
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 |
|
| ||||
CREATE CLUSTER |
|
| ||||
CREATE DATABASE LINK |
|
| ||||
CREATE LIBRARY |
|
|
| |||
CREATE PROCEDURE |
|
|
| |||
CREATE PROFILE |
|
| ||||
CREATE PUBLIC DATABASE LINK |
|
| ||||
CREATE PUBLIC SYNONYM |
|
|
|
| ||
CREATE ROLE |
|
| ||||
CREATE ROLLBACK SEGMENT |
|
| ||||
CREATE SEQUENCE |
|
| ||||
CREATE SESSION |
|
|
| |||
CREATE SNAPSHOT |
|
| ||||
CREATE SYNONYM |
|
| ||||
CREATE TABLE |
|
| ||||
CREATE TABLESPACE |
|
| ||||
CREATE TRIGGER |
|
| ||||
CREATE TYPE |
|
| ||||
CREATE USER |
|
| ||||
CREATE 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 |
|
| ||||
DROP PROFILE |
|
| ||||
DROP PUBLIC DATABASE LINK |
|
| ||||
DROP PUBLIC SYNONYM |
|
|
| |||
DROP ROLLBACK SEGMENT |
|
| ||||
DROP TABLESPACE |
|
| ||||
DROP USER |
|
| ||||
EXECUTE ANY LIBRARY |
|
| ||||
EXECUTE ANY PROCEDURE |
|
|
| |||
EXECUTE ANY TYPE |
|
|
| |||
FORCE ANY TRANSACTION |
|
| ||||
FORCE TRANSACTION |
|
| ||||
GRANT ANY PRIVILEGE |
|
| ||||
GRANT ANY ROLE |
|
| ||||
INSERT ANY TABLE |
|
| ||||
LOCK ANY TABLE |
|
|
| |||
MANAGE TABLESPACE |
|
| ||||
RESTRICTED SESSION |
|
| ||||
SELECT ANY SEQUENCE |
|
| ||||
SELECT ANY TABLE |
|
|
| |||
UNLIMITED TABLESPACE |
|
|
| |||
|
|
|
|
|