oracle 1111.2.0.1.0 环境
查看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_OPT
------------------------------ ------------------------------ ---------
RESOURCE CREATE TRIGGER NO
RESOURCE CREATE SEQUENCE NO
RESOURCE CREATE TYPE NO
RESOURCE CREATE PROCEDURE NO
RESOURCE CREATE CLUSTER NO
RESOURCE CREATE OPERATOR NO
RESOURCE CREATE INDEXTYPE NO
RESOURCE CREATE TABLE NO
8 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.
转播
