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)