HPE SM Oracle user settings

HPE SM Oracle user settings

sqlplus / as sysdba

create user smadmin identified by smadmin default tablespace users quota unlimited on users;

alter user smadmin default tablespace users;
alter user smadmin temporary tablespace temp;
alter user sys identified by password;

grant create materialized view TO smadmin;
grant create session ,alter session ,create synonym ,create view ,create table ,create sequence TO smadmin;
grant create table ,create cluster ,create sequence ,create trigger ,create procedure ,create type ,create indextype ,create operator TO smadmin;
grant select on dba_data_files to smadmin;
grant select on dba_extents to smadmin;
grant select on dba_tablespaces to smadmin;
grant select on dba_temp_files to smadmin;
grant select on v_$database to smadmin;
grant select on v_$session to smadmin;
grant unlimited tablespace TO smadmin;

// ALTER USER smadmin ACCOUNT UNLOCK;
// ALTER USER smadmin IDENTIFIED BY smadmin ACCOUNT UNLOCK;