SQLPlus Security/Privileges
The SQL statements GRANT and REVOKE, respectively allow /disallow access. GRANT {role | privilege_list ON object_name} TO user; ROLE ADMIN: CREATE SCHEMA, CREATE USER, ALTER USER, DROP USER, DROP SCHEMA, GRANT, and REVOKE DBA/DDL: All ADMIN privileges, CREATE TABLE, CREATE ANY TABLE, CREATE VIEW, CREATE ANY VIEW, CREATE INDEX, CREATE ANY INDEX, …