Users with explicit object privileges and the SYSDBA can access dictionary
objects. If, however, you need access to dictionary objects and do not have
explicit object privileges, you can be granted the following roles:
* SELECT_CATALOG_ROLE
Enables users to SELECT all exported catalog views and tables granted to
this role. Grant this role to users who must access all exported views and
tables in the data dictionary.
* EXECUTE_CATALOG_ROLE
Provides EXECUTE privilege on exported packages in the dictionary.
* DELETE_CATALOG_ROLE
Enables users to delete records from the AUD$ table.
These roles enable database administrators to access certain objects in the
dictionary while maintaining dictionary security.[@more@]
objects. If, however, you need access to dictionary objects and do not have
explicit object privileges, you can be granted the following roles:
* SELECT_CATALOG_ROLE
Enables users to SELECT all exported catalog views and tables granted to
this role. Grant this role to users who must access all exported views and
tables in the data dictionary.
* EXECUTE_CATALOG_ROLE
Provides EXECUTE privilege on exported packages in the dictionary.
* DELETE_CATALOG_ROLE
Enables users to delete records from the AUD$ table.
These roles enable database administrators to access certain objects in the
dictionary while maintaining dictionary security.[@more@]
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/10599713/viewspace-1001547/ ，如需转载，请注明出处，否则将追究法律责任。
上一篇：
V$LOGFILE.STATUS
下一篇：
ROLE:*CATALOG_ROLE
请登录后发表评论
登录
全部评论
-
博文量740
-
访问量2002850
最新文章
- 人力&人手&人才&人物
- oracle树中prior的用法
- Using Supplied Packages to Manage Stored Outlines
- $ORACLE_HOMERDBMSADMIN目录下各SQL的含义
- PRODUCT_USER_PROFILE Table
- Backing Up Server Parameter Files with RMAN
- Backing Up Control Files with RMAN
- Backing Up Individual Tablespaces with RMAN
- Making Whole Database Backups with RMAN
- 目睹奥运火炬传递
