Try this
You need to know which view you should query. Find your view by running this
Select table_name,comments from dict where table_name like '%PRIV%';
Then query the proper view.

--UA


-----Original Message-----
From: Padda Ashok Kumar
[mailto:oracledba-ezmlmshield-x91897398.[Email address protected]
Sent: Wednesday, May 31, 2006 12:35 PM
To: LazyDBA Discussion
Subject: RE: Roles

Try following, pls.

select a.* from role_tab_privs a, dba_roles b where a.role=b.role


--Ashok.

-----Original Message-----
From: a810700 (RICCIO CHAVEZ FRANCISCO MARTIN)
[mailto:oracledba-ezmlmshield-x3050701.[Email address protected]
Sent: Wednesday, May 31, 2006 2:46 PM
To: LazyDBA Discussion
Subject: Roles


Hi guys,

Here i have got a problem in Oracle 10g, in my database i have severals
roles for my users and i wish i knew that privileges were assigned in a
specific role. I have found the view dba_roles but it shows up me the list
of roles; but i need to know the privileges assigned for each role. If
somebody can help me in it, i will be greatful.
Thank you.
Regards.


--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html



--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html




Oracle LazyDBA home page