日期:2014-05-17  浏览次数:21087 次

请问connect 和 create session权限有和区别?
请问connect   和     create   session权限有和区别?

------解决方案--------------------
connect角色的权限包括 CREATE SESSION
------解决方案--------------------
SQL> select * from dba_sys_privs where grantee= 'CONNECT ';

GRANTEE PRIVILEGE ADMIN_OPTION
------------------------------ ---------------------------------------- ------------
CONNECT CREATE VIEW NO
CONNECT CREATE TABLE NO
CONNECT ALTER SESSION NO
CONNECT CREATE CLUSTER NO
CONNECT CREATE SESSION NO
CONNECT CREATE SYNONYM NO
CONNECT CREATE SEQUENCE NO
CONNECT CREATE DATABASE LINK NO

8 rows selected

SQL>