Privileges for DDL Commands

SYSDBA:

• CREATE TABLE

• CREATE INDEX

• DROP INDEX

• DROP TABLE

• ALTER TABLE

CREATE_ANY_TABLE:

• CREATE TABLE

DROP_ANY_TABLE:

• DROP TABLE

EVOLVE_ANY_TABLE or EVOLVE_TABLE (on $table_name):

• ALTER TABLE table_name

CREATE_ANY_INDEX or CREATE_INDEX (on $table_name):

• CREATE INDEX ON table_name

DROP_ANY_INDEX or DROP_INDEX (on $table_name):

• DROP INDEX ON table_name

SYSOPER:

• CREATE USER

• CREATE ROLE

• DROP USER

• DROP ROLE

• ALTER USER

• GRANT

• REVOKE

DBVIEW:

• SHOW TABLE

• SHOW INDEX

• DESCRIBE TABLE

• DESCRIBE INDEX

SYSVIEW:

• SHOW USERS

• SHOW ROLES

USRVIEW:

• SHOW USERS (for self only)