-- Create the user create user PERSONNEL_MANAGE identified by "MWQ" default tablespace USERS temporary tablespace TEMP profile DEFAULT quota 1024m on sysaux; -- Grant/Revoke role privileges grant aq_administrator_role to PERSONNEL_MANAGE with admin option; -- Grant/Revoke system privileges grant administer any sql tuning set to PERSONNEL_MANAGE with admin option;
-- Modify the user alter user PERSONNEL_MANAGE identified by MWQ; -- Grant/Revoke object privileges grant select, insert, update, delete on ALL_APPLY to PERSONNEL_MANAGE; -- Grant/Revoke role privileges revoke AQ_ADMINISTRATOR_ROLE from PERSONNEL_MANAGE; grant connect to PERSONNEL_MANAGE with admin option; grant dba to PERSONNEL_MANAGE with admin option; -- Grant/Revoke system privileges grant administer sql tuning set to PERSONNEL_MANAGE with admin option;
