create user user1
identified by values 'fa091872a2cc669c'
default tablespace user1
temporary tablespace temp
PRofile default
account unlock;
-- 4 roles for user1
grant recovery_cata
LOG_owner to user1 with admin option;
grant resource to user1 with admin option;
grant dba to user1 with admin option;
grant connect to user1 with admin option;
alter user user1 default role all;
-- 3 system privileges for user1
grant select any dictionary to user1 with admin option;
grant unlimited tablespace to user1 with admin option;
grant alter any procedure to user1 with admin option;