有11gr2環境的朋友,幫忙看下,dbsnmp用戶有哪些權限

显示全部楼层 · 2006-5-5 16:12:24

誰幫我看一下11gr2 dbsnmp用戶有哪些權限，如role,system prive,object privs
不小心把生產庫的dbsnmp用戶給刪了，公司只有這一台是11g，拜托了
謝謝
[ 本帖最后由 hzh_hu 于 2011-1-12 10:45 编辑 ]

千问 · 2006-5-5 16:12:24

SQL> select grantee,privilege from dba_sys_privs
2where grantee='DBSNMP';
GRANTEE
PRIVILEGE
------------------------------ ----------------------------------------
DBSNMP
CREATE PROCEDURE
DBSNMP
UNLIMITED TABLESPACE
DBSNMP
SELECT ANY DICTIONARY
DBSNMP
CREATE TABLE
SQL> select grantee granted_role from dba_role_privs
2where grantee='DBSNMP';
GRANTED_ROLE
------------------------------
DBSNMP

千问 · 2006-5-5 16:12:24

謝謝
還有slect* from dba_tab_privs也幫我看一下，好嗎
另外，我的11gr2怎沒有dbsnmp這個role呢?

千问 · 2006-5-5 16:12:24

$ORACLE_HOME/rdbms/admin/catnsnmp.sql
来删除它

$ORACLE_HOME/rdbms/admin/catsnmp.sql
来重建!

千问 · 2006-5-5 16:12:24

SQL> select * from dba_tab_privs where grantee='DBSNMP';
GRANTEE
OWNER
------------------------------ ------------------------------
TABLE_NAME
GRANTOR
------------------------------ ------------------------------
PRIVILEGE
GRA HIE
---------------------------------------- --- ---
DBSNMP
SYS
DBMS_SERVER_ALERT
SYS
EXECUTE
NONO
DBSNMP
SYS
DBMS_MANAGEMENT_PACKS
SYS
EXECUTE
NONO
GRANTEE
OWNER
------------------------------ ------------------------------
TABLE_NAME
GRANTOR
------------------------------ ------------------------------
PRIVILEGE
GRA HIE
---------------------------------------- --- ---
DBSNMP
APPQOSSYS
WLM_CLASSIFIER_PLAN
APPQOSSYS
SELECT
NONO
DBSNMP
APPQOSSYS
WLM_METRICS_STREAM
APPQOSSYS
GRANTEE
OWNER
------------------------------ ------------------------------
TABLE_NAME
GRANTOR
------------------------------ ------------------------------
PRIVILEGE
GRA HIE
---------------------------------------- --- ---
SELECT
NONO

千问 · 2006-5-5 16:12:24

還要麻煩您一下
SQL> select grantee granted_role from dba_role_privs
2where grantee='DBSNMP';
可否改成下面的run一下，grantee與granted_role中間可能您忘了加了一個逗號

SQL> select grantee,granted_role from dba_role_privs
2where grantee='DBSNMP';