Previous Next JavaScript must be enabled to correctly display this content

## 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)