CREATE USER U1 IDENTIFIED BY U1;
CREATE USER U2 IDENTIFIED BY U2;

GRANT CREATE SESSION TO U1,U2;



GRANT SELECT ON CARS TO U1,U2;
GRANT SELECT ON CUSTOMERS TO U1,U2;
GRANT SELECT ON CONTRACTS TO U1,U2;
GRANT SELECT ON EMPLOYEES TO U1,U2;
GRANT SELECT ON ACCEDENTS TO U1,U2;
GRANT SELECT ON WORKSHOPS TO U1,U2;
GRANT SELECT ON MAINTENANCE TO U1,U2;
GRANT SELECT ON v_contracts TO U1,U2;
grant select on company_cars to u1,u2;

GRANT INSERT ON CARS TO U1;
GRANT INSERT ON CUSTOMERS TO U1;
GRANT INSERT ON CONTRACTS TO U1;
GRANT INSERT ON EMPLOYEES TO U1;
GRANT INSERT ON ACCEDENTS TO U1;
GRANT INSERT ON WORKSHOPS TO U1;
GRANT INSERT ON MAINTENANCE TO U1;



GRANT UPDATE,DELETE ON CARS TO U2;
GRANT UPDATE,DELETE ON CUSTOMERS TO U2;
GRANT UPDATE,DELETE ON CONTRACTS TO U2;
GRANT UPDATE,DELETE ON EMPLOYEES TO U2;
GRANT UPDATE,DELETE ON ACCEDENTS TO U2;
GRANT UPDATE,DELETE ON WORKSHOPS TO U2;
GRANT UPDATE,DELETE ON MAINTENANCE TO U2;

create role abd;
grant    SELECT ON CARS ,
SELECT ON CUSTOMERS ,
 SELECT ON CONTRACTS ,
 SELECT ON EMPLOYEES ,
 SELECT ON ACCEDENTS ,
 SELECT ON WORKSHOPS ,
 SELECT ON MAINTENANCE,
 SELECT ON v_contracts,
 select on v_cars  TO ABD;




GRANT ABD TO U1,U2;

CREATE ROLE K;

GRANT INSERT ON CARS,CUSTOMERS,CONTRACTS,EMPLOYEES,ACCEDENTS,WORKSHOPS,MAINTENANCE TO K;
GRANT K TO U1;



