sqlplus /nolog
conn / as sysdba
1 建立用户
Create User orcldba Identified by zcs001;
2 创建角色
Create role orclrole;
3 授权给角色
grant create session to orclrole;
grant select on v_$sysstat to orclrole;
grant select on v_$system_event to orclrole;
grant select on v_$rowcache to orclrole;
grant select on v_$librarycache to orclrole;
grant select on V_$INSTANCE to orclrole;
grant select on V_$STATNAME to orclrole;
grant select on V_$SESSION to orclrole;
grant select on v_$process to orclrole;
grant select on V_$SESSTAT to orclrole;
grant select on dba_data_files to orclrole;
grant select on dba_free_space to orclrole;
4 授予角色给用户
Grant orclrole to orcldba;