Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> How to pull all privileges assigned to roles?

How to pull all privileges assigned to roles?

From: the_vinman <the_vinman_at_pobox.com>
Date: 5 Jul 2006 11:25:49 -0700
Message-ID: <1152123949.360042.106680@m79g2000cwm.googlegroups.com>


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

thx
Vinman Received on Wed Jul 05 2006 - 13:25:49 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US