Oracle 10g System Privileges

SELECT privilege
FROM dba_sys_privs
WHERE grantee = 'CONNECT';
 
"CREATE SESSION"

SELECT privilege
FROM dba_sys_privs
WHERE grantee = 'RESOURCE':
 
"CREATE TRIGGER"
"CREATE SEQUENCE"
"CREATE TYPE"
"CREATE PROCEDURE"
"CREATE CLUSTER"
"CREATE OPERATOR"
"CREATE INDEXTYPE"
"CREATE TABLE"