Fighting for Dream

1

CREATE USER monadm IDENTIFIED BY monadm;

create user monadm identified by monadm;

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19

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;

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;