select_catalog_role vs select any dictionary

cneo2012

于 2008-03-27 10:37:33 发布

阅读量119

点赞数

本文介绍了在数据库中角色与特权的使用区别，角色需要重新登录或显式设置才能生效，而授予的特权则立即生效。此外还解释了select_catalog_role和select_any_dictionary的作用及区别。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

Roles need relogin or explicit set role from a session to take affect
whereas the granting of privileges take immediate affect.

select_catalog_role allows you to select on the catalog views (dba%, v$%...).
select any dictionary allows you to select the dictionary tables that is sys tables.
You can't select sys tables with only select_catalog_role role.

Users with Sysdba privileges can access the sys schema, another method of
giving system privileges without giving Sysdba privilege Is giving the
SELECT_CATALOG_ROLE. allow SELECT privileges on all data dictionary views.

[@more@]

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

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