Repository query to fetch User groups and users in it.

Can somebody give me PowerCenter Repository query(Oracle/SQLServer) to fetch below;
1. Fetch a specific User group and its members. Eg: Group Grp1 has members usr1, usr2, usr3, usr4, and usr5.
2. Fetch a specific Relational connection name and who has what kind of access. Eg: Users usr1,usr2, and usr3 has R/W/X permission on Rel_Conn1. Or Groups grp1, grp2, and grp3 has R/X permission on Rel_Conn1

I tried OPB_USER_GROUP table, but couldn't find relevant information.


Repository query to fetch User groups and users in it.

hope this works



--Find the group id

select

OPB_GROUPS



--find the users in the group



select * from

OPB_USERS

where user_id in(select user_id from OPB_USER_GROUPS where GROUP_ID=<GRP_ID>)

* from INFAPCREPO8.