這篇文章主要介紹數據庫中如何實現普通用戶服務特殊管理權限，文中介紹的非常詳細，具有一定的參考價值，感興趣的小伙伴們一定要看完！

成都創新互聯公司是專業的永城網站建設公司，永城接單;提供成都網站設計、成都做網站、外貿網站建設,網頁設計,網站設計,建網站,PHP網站建設等專業做網站服務;采用PHP框架,可快速的進行永城網站開發網頁制作和功能擴展;專業做搜索引擎喜愛的網站,專業的做網站團隊,希望更多企業前來合作!

普通用戶服務生成AWR報告權限：
grant select any dictionary to user;
grant execute on DBMS_WORKLOAD_REPOSITORY to user;
測試通過過了。

普通用戶賦予查看數據字典權限：
直接賦予
select_catalog_role角色給普通用戶就可以了。

select_catalog_role角色包含了如下的權限。

SQL> select * from ROLE_ROLE_PRIVS where role='SELECT_CATALOG_ROLE';

ROLE                                                                                       GRANTED_ROLE                                                                     ADMIN_OPT
------------------------------------------------------------------------------------------ ------------------------------------------------------------------------------------------ ---------
SELECT_CATALOG_ROLE                                                                        HS_ADMIN_SELECT_ROLE                                                             NO

該角色擁有的權限大體是如下列出的，由于權限太多，并未全部列出。
grant select on SYS.DBA_HIST_LATCH_NAME to SELECT_CATALOG_ROLE;
grant select on SYS.DBA_HIST_LATCH_PARENT to SELECT_CATALOG_ROLE;
grant select on SYS.DBA_HIST_LIBRARYCACHE to SELECT_CATALOG_ROLE;
grant select on SYS.DBA_HIST_LOG to SELECT_CATALOG_ROLE;
grant select on SYS.DBA_HIST_MEMORY_RESIZE_OPS to SELECT_CATALOG_ROLE;
grant select on SYS.DBA_HIST_MEMORY_TARGET_ADVICE to SELECT_CATALOG_ROLE;
grant select on SYS.DBA_HIST_MEM_DYNAMIC_COMP to SELECT_CATALOG_ROLE;
grant select on SYS.DBA_HIST_METRIC_NAME to SELECT_CATALOG_ROLE;
grant select on SYS.DBA_HIST_MTTR_TARGET_ADVICE to SELECT_CATALOG_ROLE;
grant select on SYS.DBA_HIST_MUTEX_SLEEP to SELECT_CATALOG_ROLE;
grant select on SYS.DBA_HIST_MVPARAMETER to SELECT_CATALOG_ROLE;
grant select on SYS.DBA_HIST_OPTIMIZER_ENV to SELECT_CATALOG_ROLE;
grant select on SYS.DBA_HIST_OSSTAT to SELECT_CATALOG_ROLE;
grant select on SYS.DBA_HIST_OSSTAT_NAME to SELECT_CATALOG_ROLE;
grant select on SYS.DBA_HIST_PARAMETER to SELECT_CATALOG_ROLE;
grant select on SYS.DBA_HIST_PARAMETER_NAME to SELECT_CATALOG_ROLE;
grant select on SYS.DBA_HIST_PERSISTENT_QMN_CACHE to SELECT_CATALOG_ROLE;
grant select on SYS.DBA_HIST_PERSISTENT_QUEUES to SELECT_CATALOG_ROLE;
grant select on SYS.DBA_HIST_PERSISTENT_SUBS to SELECT_CATALOG_ROLE;
grant select on SYS.DBA_HIST_PGASTAT to SELECT_CATALOG_ROLE;
grant select on SYS.DBA_HIST_PGA_TARGET_ADVICE to SELECT_CATALOG_ROLE;
grant select on SYS.DBA_HIST_PLAN_OPERATION_NAME to SELECT_CATALOG_ROLE;
grant select on SYS.DBA_HIST_PLAN_OPTION_NAME to SELECT_CATALOG_ROLE;
grant select on SYS.DBA_HIST_PROCESS_MEM_SUMMARY to SELECT_CATALOG_ROLE;
grant select on SYS.DBA_HIST_RESOURCE_LIMIT to SELECT_CATALOG_ROLE;
grant select on SYS.DBA_HIST_ROWCACHE_SUMMARY to SELECT_CATALOG_ROLE;
grant select on SYS.DBA_HIST_RSRC_CONSUMER_GROUP to SELECT_CATALOG_ROLE;
grant select on SYS.DBA_HIST_RSRC_PLAN to SELECT_CATALOG_ROLE;
grant select on SYS.DBA_HIST_RULE_SET to SELECT_CATALOG_ROLE;
grant select on SYS.DBA_HIST_SEG_STAT to SELECT_CATALOG_ROLE;
grant select on SYS.DBA_HIST_SEG_STAT_OBJ to SELECT_CATALOG_ROLE;
grant select on SYS.DBA_HIST_SERVICE_NAME to SELECT_CATALOG_ROLE;
grant select on SYS.DBA_HIST_SERVICE_STAT to SELECT_CATALOG_ROLE;
grant select on SYS.DBA_HIST_SERVICE_WAIT_CLASS to SELECT_CATALOG_ROLE;
grant select on SYS.DBA_HIST_SESSMETRIC_HISTORY to SELECT_CATALOG_ROLE;
grant select on SYS.DBA_HIST_SESS_TIME_STATS to SELECT_CATALOG_ROLE;
grant select on SYS.DBA_HIST_SGA to SELECT_CATALOG_ROLE;
grant select on SYS.DBA_HIST_SGASTAT to SELECT_CATALOG_ROLE;
grant select on SYS.DBA_HIST_SGA_TARGET_ADVICE to SELECT_CATALOG_ROLE;
grant select on SYS.DBA_HIST_SHARED_POOL_ADVICE to SELECT_CATALOG_ROLE;
grant select on SYS.DBA_HIST_SHARED_SERVER_SUMMARY to SELECT_CATALOG_ROLE;
grant select on SYS.DBA_HIST_SNAPSHOT to SELECT_CATALOG_ROLE;
grant select on SYS.DBA_HIST_SNAP_ERROR to SELECT_CATALOG_ROLE;
grant select on SYS.DBA_HIST_SQLBIND to SELECT_CATALOG_ROLE;
grant select on SYS.DBA_HIST_SQLCOMMAND_NAME to SELECT_CATALOG_ROLE;
grant select on SYS.DBA_HIST_SQLSTAT to SELECT_CATALOG_ROLE;
grant select on SYS.DBA_HIST_SQLTEXT to SELECT_CATALOG_ROLE;
grant select on SYS.DBA_HIST_SQL_BIND_METADATA to SELECT_CATALOG_ROLE;
grant select on SYS.DBA_HIST_SQL_PLAN to SELECT_CATALOG_ROLE;
grant select on SYS.DBA_HIST_SQL_SUMMARY to SELECT_CATALOG_ROLE;
grant select on SYS.DBA_HIST_SQL_WORKAREA_HSTGRM to SELECT_CATALOG_ROLE;
grant select on SYS.DBA_HIST_STAT_NAME to SELECT_CATALOG_ROLE;
grant select on SYS.DBA_HIST_STREAMS_APPLY_SUM to SELECT_CATALOG_ROLE;
grant select on SYS.DBA_HIST_STREAMS_CAPTURE to SELECT_CATALOG_ROLE;
grant select on SYS.DBA_HIST_STREAMS_POOL_ADVICE to SELECT_CATALOG_ROLE;
grant select on SYS.DBA_HIST_SYSMETRIC_HISTORY to SELECT_CATALOG_ROLE;
grant select on SYS.DBA_HIST_SYSMETRIC_SUMMARY to SELECT_CATALOG_ROLE;
grant select on SYS.DBA_HIST_SYSSTAT to SELECT_CATALOG_ROLE;
grant select on SYS.DBA_HIST_SYSTEM_EVENT to SELECT_CATALOG_ROLE;
grant select on SYS.DBA_HIST_SYS_TIME_MODEL to SELECT_CATALOG_ROLE;
grant select on SYS.DBA_HIST_TABLESPACE to SELECT_CATALOG_ROLE;
grant select on SYS.DBA_HIST_TABLESPACE_STAT to SELECT_CATALOG_ROLE;
grant select on SYS.DBA_HIST_TBSPC_SPACE_USAGE to SELECT_CATALOG_ROLE;
grant select on SYS.DBA_HIST_TEMPFILE to SELECT_CATALOG_ROLE;
grant select on SYS.DBA_HIST_TEMPSTATXS to SELECT_CATALOG_ROLE;
grant select on SYS.DBA_HIST_THREAD to SELECT_CATALOG_ROLE;
grant select on SYS.DBA_HIST_TOPLEVELCALL_NAME to SELECT_CATALOG_ROLE;
grant select on SYS.DBA_HIST_UNDOSTAT to SELECT_CATALOG_ROLE;
grant select on SYS.DBA_HIST_WAITCLASSMET_HISTORY to SELECT_CATALOG_ROLE;
grant select on SYS.DBA_HIST_WAITSTAT to SELECT_CATALOG_ROLE;
grant select on SYS.DBA_HIST_WR_CONTROL to SELECT_CATALOG_ROLE;
grant select on SYS.DBA_IAS_CONSTRAINT_EXP to SELECT_CATALOG_ROLE;
grant select on SYS.DBA_IAS_GEN_STMTS to SELECT_CATALOG_ROLE;
grant select on SYS.DBA_IAS_GEN_STMTS_EXP to SELECT_CATALOG_ROLE;
grant select on SYS.DBA_IAS_OBJECTS to SELECT_CATALOG_ROLE;
grant select on SYS.DBA_IAS_OBJECTS_BASE to SELECT_CATALOG_ROLE;
grant select on SYS.DBA_IAS_OBJECTS_EXP to SELECT_CATALOG_ROLE;
grant select on SYS.DBA_IAS_POSTGEN_STMTS to SELECT_CATALOG_ROLE;
grant select on SYS.DBA_IAS_PREGEN_STMTS to SELECT_CATALOG_ROLE;
grant select on SYS.DBA_IAS_SITES to SELECT_CATALOG_ROLE;
grant select on SYS.DBA_IAS_TEMPLATES to SELECT_CATALOG_ROLE;
grant select on SYS.DBA_IDENTIFIERS to SELECT_CATALOG_ROLE;
grant select on SYS.DBA_INDEXES to SELECT_CATALOG_ROLE;
grant select on SYS.DBA_INDEXTYPES to SELECT_CATALOG_ROLE;
grant select on SYS.DBA_INDEXTYPE_ARRAYTYPES to SELECT_CATALOG_ROLE;
grant select on SYS.DBA_INDEXTYPE_COMMENTS to SELECT_CATALOG_ROLE;
grant select on SYS.DBA_INDEXTYPE_OPERATORS to SELECT_CATALOG_ROLE;
grant select on SYS.DBA_IND_COLUMNS to SELECT_CATALOG_ROLE;
grant select on SYS.DBA_IND_EXPRESSIONS to SELECT_CATALOG_ROLE;
grant select on SYS.DBA_IND_PARTITIONS to SELECT_CATALOG_ROLE;
grant select on SYS.DBA_IND_STATISTICS to SELECT_CATALOG_ROLE;
grant select on SYS.DBA_IND_SUBPARTITIONS to SELECT_CATALOG_ROLE;
grant select on SYS.DBA_INTERNAL_TRIGGERS to SELECT_CATALOG_ROLE;
grant select on SYS.DBA_INVALID_OBJECTS to SELECT_CATALOG_ROLE;
grant select on SYS.DBA_JAVA_ARGUMENTS to SELECT_CATALOG_ROLE;
grant select on SYS.DBA_JAVA_CLASSES to SELECT_CATALOG_ROLE;
grant select on SYS.DBA_JAVA_COMPILER_OPTIONS to SELECT_CATALOG_ROLE;
grant select on SYS.DBA_JAVA_DERIVATIONS to SELECT_CATALOG_ROLE;
grant select on SYS.DBA_JAVA_FIELDS to SELECT_CATALOG_ROLE;
grant select on SYS.DBA_JAVA_IMPLEMENTS to SELECT_CATALOG_ROLE;
grant select on SYS.DBA_JAVA_INNERS to SELECT_CATALOG_ROLE;
grant select on SYS.DBA_JAVA_LAYOUTS to SELECT_CATALOG_ROLE;
grant select on SYS.DBA_JAVA_METHODS to SELECT_CATALOG_ROLE;
grant select on SYS.DBA_JAVA_NCOMPS to SELECT_CATALOG_ROLE;
grant select on SYS.DBA_JAVA_POLICY to SELECT_CATALOG_ROLE;
grant select on SYS.DBA_JAVA_RESOLVERS to SELECT_CATALOG_ROLE;
grant select on SYS.DBA_JAVA_THROWS to SELECT_CATALOG_ROLE;
grant select on SYS.DBA_JOBS to SELECT_CATALOG_ROLE;
grant select on SYS.DBA_JOBS_RUNNING to SELECT_CATALOG_ROLE;
grant select on SYS.DBA_JOIN_IND_COLUMNS to SELECT_CATALOG_ROLE;
grant select on SYS.DBA_KGLLOCK to SELECT_CATALOG_ROLE;
grant select on SYS.DBA_LIBRARIES to SELECT_CATALOG_ROLE;
grant select on SYS.DBA_LMT_FREE_SPACE to SELECT_CATALOG_ROLE;
grant select on SYS.DBA_LMT_USED_EXTENTS to SELECT_CATALOG_ROLE;
grant select on SYS.DBA_LOBS to SELECT_CATALOG_ROLE;
grant select on SYS.DBA_LOB_PARTITIONS to SELECT_CATALOG_ROLE;
grant select on SYS.DBA_LOB_SUBPARTITIONS to SELECT_CATALOG_ROLE;
grant select on SYS.DBA_LOB_TEMPLATES to SELECT_CATALOG_ROLE;

以上是“數據庫中如何實現普通用戶服務特殊管理權限”這篇文章的所有內容，感謝各位的閱讀！希望分享的內容對大家有幫助，更多相關知識，歡迎關注創新互聯行業資訊頻道！

網站題目：數據庫中如何實現普通用戶服務特殊管理權限
本文路徑：http://www.yijiale78.com/article12/ihojgc.html

成都網站建設公司_創新互聯，為您提供品牌網站建設、外貿網站建設、網站營銷、網站設計公司、品牌網站設計、微信公眾號

廣告

聲明：本網站發布的內容（圖片、視頻和文字）以用戶投稿、用戶轉載內容為主，如果涉及侵權請盡快告知，我們將會在第一時間刪除。文章觀點不代表本網站立場，如需處理請聯系客服。電話：028-86922220；郵箱：631063699@qq.com。內容未經允許不得轉載，或轉載時需注明來源： 創新互聯