想知道一个USER 当前被授予了什么ROLES??

显示全部楼层 · 2011-11-16 22:31:22

千问 · 2011-11-16 22:31:22

知道了 , 好象是DBA_ROLE_PRIVS
不过我不知道DBA_ROLE_PRIVS里的RESOURCE是什么权限?

千问 · 2011-11-16 22:31:22

资源权限。

千问 · 2011-11-16 22:31:22

试试这样吧
SQL> conn system/manager
Connected.
SQL> select * from session_roles;
ROLE
------------------------------
DBA
SELECT_CATALOG_ROLE
HS_ADMIN_ROLE
EXECUTE_CATALOG_ROLE
DELETE_CATALOG_ROLE
EXP_FULL_DATABASE
IMP_FULL_DATABASE
GATHER_SYSTEM_STATISTICS
WM_ADMIN_ROLE
JAVA_ADMIN
JAVA_DEPLOY
XDBADMIN
OLAP_DBA
PLUSTRACE
AQ_ADMINISTRATOR_ROLE
SALES_HISTORY_ROLE
16 rows selected.
SQL> create user t
2identified by t;
User created.
SQL> grant connect,resource to t;
Grant succeeded.
SQL> conn t/t
Connected.
SQL> select * from session_roles;
ROLE
------------------------------
CONNECT
RESOURCE
SQL>

千问 · 2011-11-16 22:31:22

查ROLE具有的系统权限，试试如下
SQL> conn t/t
Connected.
SQL> select * from session_roles;
ROLE
------------------------------
CONNECT
RESOURCE
SQL> select privilege
2from role_sys_privs
3where role='RESOURCE';
PRIVILEGE
----------------------------------------
CREATE TYPE
CREATE TABLE
CREATE CLUSTER
CREATE TRIGGER
CREATE OPERATOR
CREATE SEQUENCE
CREATE INDEXTYPE
CREATE PROCEDURE
8 rows selected.
SQL> select privilege
2from role_sys_privs
3where role='CONNECT';
PRIVILEGE
----------------------------------------
CREATE VIEW
CREATE TABLE
ALTER SESSION
CREATE CLUSTER
CREATE SESSION
CREATE SYNONYM
CREATE SEQUENCE
CREATE DATABASE LINK
8 rows selected.

千问 · 2011-11-16 22:31:22

察看被授予的角色应该是DBA_ROLE_PRIVS，session_roles看的是当前会话启用的角色

千问 · 2011-11-16 22:31:22

最初由 Ora-600 发布
[B]察看被授予的角色应该是DBA_ROLE_PRIVS，session_roles看的是当前会话启用的角色 [/B]
同意！