Shulou(Shulou.com)05/31 Report--

This article mainly introduces how to achieve the special management rights of ordinary user services in the database, which is very detailed and has a certain reference value. Interested friends must finish reading it!

Normal user service generates AWR report permissions:

Grant select any dictionary to user

Grant execute on DBMS_WORKLOAD_REPOSITORY to user

I passed the test.

Ordinary users are granted permission to view data dictionaries:

Direct endowment

The select_catalog_role role can be given to ordinary users.

The select_catalog_role role contains the following permissions.

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

ROLE GRANTED_ROLE ADMIN_OPT

SELECT_CATALOG_ROLE HS_ADMIN_SELECT_ROLE NO

The permissions that the role has are roughly listed below, but not all of them are listed because there are too many permissions.

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

The above is all the contents of the article "how to realize the special management rights of ordinary user services in the database". Thank you for reading! Hope to share the content to help you, more related knowledge, welcome to follow the industry information channel!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.