灌溉梦想,记录脚步
« »
2012 年 02 月 22 日技术合集

Oracle监控账户权限的推荐配置

建立用户:

1
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;

日志信息 »

该日志于2012-02-22 00:42由 kevin 发表在技术合集分类下, 你可以发表评论。除了可以将这个日志以保留源地址及作者的情况下引用到你的网站或博客,还可以通过RSS 2.0订阅这个日志的所有评论。

没有评论

发表评论 »