Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
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;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
You can’t perform that action at this time.