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