角色，用户，权限

来源：互联网发布：windows窗口api 编辑：程序博客网时间：2024/05/17 08:10

已SYSTEM用户为例，查询所属的角色及拥有的权限

所属角色：

SQL> select grantee,granted_role from dba_role_privs where grantee='SYSTEM';GRANTEE                        GRANTED_ROLE----------------------------   ------------------------------SYSTEM                         AQ_ADMINISTRATOR_ROLESYSTEM                         DBA

角色权限：

SQL> select * from role_sys_privs  where role='DBA';ROLE                          PRIVILEGE                        ADM-----------------             ------------------------         ----------------DBA                           CREATE SESSION                   YESDBA                           ALTER SESSION                    YES......

用户权限：

SQL> select * from dba_sys_privs where grantee='SYSTEM';GRANTEE                        PRIVILEGE                          ADM--------------------------     ------------------------           -----------------SYSTEM                         GLOBAL QUERYREWRITE                NOSYSTEM                         CREATE MATERIALIZEDVIEW            NOSYSTEM                         CREATE TABLE                       NOSYSTEM                         UNLIMITEDTABLESPACE                YESSYSTEM                         SELECT ANY TABLE                   NO

查看用户的所有权限：

select privilege from dba_sys_privs where grantee='SYSTEM' union select privilege from dba_sys_privs where grantee in (select granted_role from dba_role_privs where grantee='SYSTEM' );

0 0