CREATE ROLE role_cadcim;

GRANT SELECT, INSERT, UPDATE, DELETE ON HR.EMPLOYEES TO role_cadcim;

GRANT ALL ON HR.EMPLOYEES TO role_cadcim;

GRANT CREATE PROFILE, ALTER PROFILE, DROP PROFILE,
CREATE ROLE, DROP ANY ROLE, GRANT ANY ROLE, AUDIT ANY,
AUDIT SYSTEM, CREATE USER, BECOME USER, ALTER USER, DROP USER
TO ROLE_CADCIM WITH ADMIN OPTION;

GRANT role_cadcim TO cadcim;