查看当前session权限

查看connect都有什么权限

SQL> select * from dba_sys_privs where GRANTEE=‘CONNECT‘;

GRANTEE         PRIVILEGE                                ADMIN_OPTION
--------------- ---------------------------------------- ------------
CONNECT         CREATE SESSION                           NO

1 row selected.

查看resource包含的权限

SQL> select * from dba_sys_privs where GRANTEE=‘RESOURCE‘;

GRANTEE         PRIVILEGE                                ADMIN_OPTION
--------------- ---------------------------------------- ------------
RESOURCE        CREATE TABLE                             NO
RESOURCE        CREATE SEQUENCE                          NO
RESOURCE        CREATE PROCEDURE                         NO

3 rows selected.

查看当前session包含的权限

SQL> SELECT * FROM SESSION_PRIVS ;

PRIVILEGE                               
----------------------------------------
ALTER ANY INDEX
ALTER ANY INDEXTYPE
ALTER ANY MATERIALIZED VIEW
ALTER ANY OPERATOR
ALTER ANY PROCEDURE
ALTER ANY SEQUENCE
ALTER ANY SQL TRANSLATION PROFILE
ALTER ANY TABLE
ALTER ANY TRIGGER
ALTER ANY TYPE
ALTER DATABASE
ALTER RMGR
ALTER ROLLBACK SEGMENT
ALTER SESSION

......

91 rows selected.

查看当前session权限

原文：http://www.cnblogs.com/wangqianqiannb/p/6401751.html