ruoli resource e connect in oracle

Oracle 10gR2 (decente):
  CONNECT role has only CREATE SESSION


  RESOURCE has CREATE CLUSTER, CREATE INDEXTYPE, CREATE OPERATOR, CREATE PROCEDURE, CREATE SEQUENCE, CREATE TABLE, CREATE TRIGGER and CREATE TYPE


Oracle 9iR2 (un po troppi permessi per connect):
  CONNECT has ALTER SESSION, CREATE CLUSTER, CREATE DATABASE LINK, CREATE SEQUENCE, CREATE SESSION, CREATE SYNONYM, CREATE TABLE and CREATE VIEW. Rather a scary lot for a role called ‘connect’
  
  RESOURCE has CREATE CLUSTER, CREATE INDEXTYPE, CREATE OPERATOR, CREATE PROCEDURE, CREATE SEQUENCE, CREATE TABLE, CREATE TRIGGER and CREATE TYPE

L'opzione admin vi permette di dare questi privileggi ad altri

Query per avere i privileggi di connect:
select grantee, privilege, admin_option from dba_sys_privs where grantee='CONNECT';


rif: http://www.lifeaftercoffee.com/2005/08/29/oracle-connect-and-resource-roles/