db 1-12-15

CREATE USER BATMAN
IDENTIFIED BY ROBIN;

GRANT CREATE TABLE, CREATE SEQUENCE, CREATE VIEW, CREATE TRIGGER, CONNECT, RESOURCE
TO ORC;

CREATE ROLE DETECTIVE;

GRANT CREATE TABLE, CREATE VIEW, CREATE SEQUENCE
TO BATMAN;

GRANT ALIEN
TO BATMAN;

REVOKE CREATE TABLE
FROM BATMAN;

REVOKE CREATE TABLE
FROM DETECTIVE;

GRANT DETECTIVE
TO BATMAN, SUPERMAN;

ALTER USER BATMAN
IDENTIFIED BY LIMON;

GRANT SELECT
ON SCOTT.COURSE
TO BATMAN;

GRANT SELECT
ON SCOTT.INFO
TO PUBLIC;

REVOKE SELECT
ON SCOTT.COURSE
FROM BATMAN;

GRANT SELECT
ON SCOTT.INFO
TO BATMAN
WITH GRANT OPTION;

SELECT *
FROM ROLE_TAB_PRIVS;