ITPub博客

首页 > Linux操作系统 > Linux操作系统 > All the privileges the user has

All the privileges the user has

原创 Linux操作系统 作者:yuanqc 时间:2013-07-14 22:07:04 0 删除 编辑
SQL> select PRIVILEGE from dba_sys_privs where GRANTEE='SCOTT';
PRIVILEGE
----------------------------------------
UNLIMITED TABLESPACE
SQL> select TABLE_NAME,PRIVILEGE from dba_tab_privs where GRANTEE='SCOTT';
no rows selected
SQL> select GRANTED_ROLE from dba_role_privs where GRANTEE='SCOTT';
GRANTED_ROLE
------------------------------
RESOURCE
SELECT_CATALOG_ROLE
CONNECT
 
To find the role who has the system privileges
SQL> select PRIVILEGE from dba_sys_privs where GRANTEE='RESOURCE';
PRIVILEGE
----------------------------------------
CREATE TRIGGER
CREATE SEQUENCE
CREATE TYPE
CREATE PROCEDURE
CREATE CLUSTER
CREATE OPERATOR
CREATE INDEXTYPE
CREATE TABLE
8 rows selected.
SQL>
To find the role who has the object privileges
SQL> select TABLE_NAME,PRIVILEGE from dba_tab_privs where GRANTEE='SELECT_CATALOG_ROLE' and rownum<5;
TABLE_NAME                     PRIVILEGE
------------------------------ ----------------------------------------
MAP_OBJECT                     SELECT
OL$                            SELECT
OL$HINTS                       SELECT
OL$NODES                       SELECT

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

请登录后发表评论 登录
全部评论

注册时间:2010-11-23

  • 博文量
    48
  • 访问量
    103887