How can I get enabled roles list ?

Hi all !

Can anyone give me an answer for the following quesion: I need to get a full list of roles, enabled for an user or role, including roles that granted directly or via another roles in role hierarchy as well. I need something about

select *
from
dba_role_privs
start with grantee = user
connect by prior grantee = granted_role

But it doesn't work. It causes 'ORA-01472: cannot use CONNECT BY on view with DISTINCT, GROUP BY, etc.'. Any ideas ?

P.S. Duplicate answers ( if any :( ) to my e-mail please...

--
Is There A God Or Any Kind Of Justice Under The Sky... (Queen'91)

Igor V. Podolsky (igoryok_at_soft-review.kiev.ua) Received on Wed Nov 03 1999 - 08:28:03 CST