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)