Accessing Frequently Used Dictionary Objects

最新推荐文章于 2025-12-17 14:20:19 发布

转载最新推荐文章于 2025-12-17 14:20:19 发布 · 77 阅读

文章标签：

#数据库

本文介绍了在数据库中访问字典对象所需的权限角色，包括SELECT_CATALOG_ROLE、EXECUTE_CATALOG_ROLE和DELETE_CATALOG_ROLE等，并解释了这些角色如何帮助管理员在确保安全的同时访问必要的字典对象。

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@]

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/10599713/viewspace-1001547/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/10599713/viewspace-1001547/