create role connection;
create role selection;
create role insertion;
create role deletion;
create role updating;
*******************************************
grant create session to connection;

********************************************
grant select on cars to selection;
grant select on employees to selection;
grant select on customers to selection;
grant select on contracts to selection;
grant select on accedents to selection;
grant select on workshops to selection;
grant select on maintenance to selection;
grant select on AUDIT_CONTRACTS          to selection;
grant select on AUDIT_EMPLOYEES          to selection;
grant select on AUDIT_MAINTENANCE        to selection;
grant select on V_CARS           to selection;
grant select on V_CARS_CONTRACTS_CUST    to selection;
grant select on V_CONTRACTS              to selection;

************************************************************
grant insert on cars to insertion;
grant insert on employees   to insertion;
grant insert on customers  to insertion;
grant insert on  contracts to insertion;
grant insert on  accedents to insertion;
grant insert on workshops to insertion;
grant insert on  maintenance to insertion;

****************************************************************
grant delete on cars to  deletion; 
grant delete on employees to  deletion; 
grant delete on customers  to deletion; 
grant delete on  contracts to deletion; 
grant delete on  accedents to deletion; 
grant delete on workshops to deletion; 
grant delete on  maintenance to deletion; 

******************************************************************
grant update on cars to  updating; 
grant update on employees to   updating;
grant update on customers  to  updating;
grant update on  contracts to  updating;
grant update on  accedents to  updating;
grant update on workshops to  updating;
grant update on  maintenance to  updating;

*********************************************************
