建立用户:

create user monadm identified by monadm;

赋权:

grant resource,connect,select_catalog_role to monadm;
grant select on v_$DATABASE to monadm;
grant select on v_$INSTANCE to monadm;
grant select on sys.props$ to monadm;
grant select on v_$sysstat to monadm;
grant select on v_$parameter to monadm;
grant select on v_$sga to monadm;
grant select on v_$rowcache to monadm;
grant select on v_$librarycache to monadm;
grant select on dba_data_files to monadm;
grant select on v_$log to monadm;
grant select on dba_tablespaces to monadm;
grant select on dba_free_space to monadm;
grant select on dba_segments to monadm;
grant select on v_$resource_limit to monadm;
grant select on v_$bgprocess to monadm;
grant select on v_$session to monadm;
grant select on v_$lock to monadm;
grant select on v_$sqltext to monadm;