Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> 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 toolReceived on Wed Jul 05 2006 - 13:41:40 CDT
![]() |
![]() |