Re: How to pull all privileges assigned to roles?

On 5 Jul 2006 11:25:49 -0700, "the_vinman" <the_vinman_at_pobox.com> wrote:

>Customer looking for info for an Audit, needs user info etc , which i
>have but also wants to know what all the roles assigned to those users
>give access to. They have many special roles we created for various
>select access etc. what would query have to be to dump like all the
>objects assigned via a role? i can go into OEM and look at the role and
>see all the objects assigned to it and the perms etc so must be some
>way. Any info would be appreciate

 Searching Google finds:
 http://www.adp-gmbh.ch/ora/misc/recursively_list_privilege.html  ... which seems to either give what you want, or can be adapted to do so.

-- 
Andy Hassall :: andy@andyh.co.uk :: http://www.andyh.co.uk
http://www.andyhsoftware.co.uk/space :: disk and FTP usage analysis tool