Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

List of all users

rootsmanJul 20 2010 — edited Jul 20 2010

How to list ALL ACTIVE users from atabase together with assigned ROLES that they have? Any ideas?
I have tried with DBA_ROLE_PRIVS view but its not so good because it list roles also with users under GRANTEE column.

I need this ASAP, it for audit!

Thanks!

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 17 2010

Added on Jul 20 2010

#general-database-discussions

3 comments

534 views