Skip to Main Content

SQL & PL/SQL

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 roles and grants for specified schemas...

leonhardtkSep 17 2012 — edited Sep 21 2012
How do I find the Roles/grantees for each schema in my list? For example, I have about 5 schemas that each have an admin and user role assigned to them. What I would like is a table that shows who is assigned to the roles for each schema.

For example:

SCHEMA ROLE USERS ASSIGNED
======= =============== ==========================

SCHEMA 1 ADMIN_ROLE_SCHEMA_1 USER_1 USER_2 USER_3 USER_4

USER_ROLE_SCHEMA_1 USER_5 USER_6 USER_7 USER_8 .........
......... .......... .......... ..........
USER_45 USER_46 USER_47 USER 48


SCHEMA 2 ADMIN_ROLE_SCHEMA_2 USER_1 USER_2 USER_3 USER_4

USER_ROLE_SCHEMA_2 USER_5 USER_6 USER_7 USER_8 .........
......... .......... .......... ..........
USER_45 USER_46 USER_47 USER 48


SCHEMA 1 ADMIN_ROLE_SCHEMA_3 USER_1 USER_2 USER_3 USER_4

USER_ROLE_SCHEMA_3 USER_5 USER_6 USER_7 USER_8 .........
......... .......... .......... ..........
USER_45 USER_46 USER_47 USER 48


(SORRY, I can't seem to get this to format correctly! This should be displayed in three columns, but is all jammed together when I post it?!)
Thanks,

KSL

Edited by: leonhardtk on Sep 17, 2012 3:35 PM

Edited by: leonhardtk on Sep 17, 2012 3:35 PM

Edited by: leonhardtk on Sep 17, 2012 3:37 PM
This post has been answered by Frank Kulash on Sep 18 2012
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 19 2012
Added on Sep 17 2012
17 comments
17,596 views