oracle 11 的CONNECT 、RESOURCE角色的权限

 CONNECT的权限：

select  privilege  from dba_sys_privs where grantee like 'CONNECT';

   PRIVILEGE                              

 ---------------------------------------- 

   CREATE SESSION  

RESOURCE的权限：

SQL> select privilege from dba_sys_privs where grantee like 'RESOURCE';

PRIVILEGE

----------------------------------------

CREATE TRIGGER

CREATE SEQUENCE

CREATE TYPE

CREATE PROCEDURE

CREATE CLUSTER

CREATE OPERATOR

CREATE INDEXTYPE

CREATE TABLE