privileges to connect role

Hi,

From which dictionary table, I know which are the privilges has been granted to connect or resource role?

Thanks

Hi,
Enter the following command:

select * from role_sys_privs where
role='CONNECT';

Regards,
Rohit Nirkhe,Oracle/Apps DBA,OCP 8i
oracle-support@indiatimes.com

BLAZE: SYS> R
1 SELECT ROLE, PRIVILEGE FROM ROLE_SYS_PRIVS
2* WHERE ROLE IN ('CONNECT', 'RESOURCE')

ROLE PRIVILEGE
------------------------------ ----------------------------------------
CONNECT ALTER SESSION
CONNECT CREATE CLUSTER
CONNECT CREATE DATABASE LINK
CONNECT CREATE SEQUENCE
CONNECT CREATE SESSION
CONNECT CREATE SYNONYM
CONNECT CREATE TABLE
CONNECT CREATE VIEW
RESOURCE CREATE CLUSTER
RESOURCE CREATE INDEXTYPE
RESOURCE CREATE OPERATOR

ROLE PRIVILEGE
------------------------------ ----------------------------------------
RESOURCE CREATE PROCEDURE
RESOURCE CREATE SEQUENCE
RESOURCE CREATE TABLE
RESOURCE CREATE TRIGGER
RESOURCE CREATE TYPE

16 rows selected.

BLAZE: SYS>

Hi