Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> How to pull all privileges assigned to roles?
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
![]() |
![]() |