select_catalog_role vs select any dictionary

最新推荐文章于 2021-11-08 16:48:18 发布

转载最新推荐文章于 2021-11-08 16:48:18 发布 · 133 阅读

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

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/