-- Create the role for the manager
CREATE ROLE MANAGER;
GRANT DBA TO MANAGER WITH ADMIN OPTION;
GRANT CREATE SESSION TO MANAGER;
GRANT CREATE TABLE TO MANAGER;
GRANT CREATE SEQUENCE TO MANAGER;
GRANT CREATE VIEW TO MANAGER;
GRANT CREATE SYNONYM TO MANAGER;
GRANT CREATE PROCEDURE TO MANAGER;
-- smoking gun priviledges
GRANT CREATE ANY TABLE TO MANAGER;
GRANT COMMENT ANY TABLE TO MANAGER;
GRANT DROP ANY TABLE TO MANAGER;
GRANT ALTER ANY TABLE TO MANAGER;

-- Grant him the manager role
GRANT MANAGER TO XCMANAGER;







-- Create the role for the user
CREATE ROLE XCONNECT_USER;
GRANT CREATE SESSION TO XCONNECT_USER;
GRANT CREATE TABLE TO XCONNECT_USER;
GRANT CREATE ANY TABLE TO XCONNECT_USER;
GRANT CREATE SEQUENCE TO XCONNECT_USER;
GRANT CREATE VIEW TO XCONNECT_USER;
GRANT CREATE SYNONYM TO XCONNECT_USER;
GRANT CREATE PROCEDURE TO XCONNECT_USER;


-- Grant him the USER role
GRANT XCONNECT_USER TO XCUSER;




