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

Question

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

Answer 1

connect角色的权限包括 CREATE SESSION

Answer 2

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                     NO8 rows selectedSQL>