Table for sap query users group and assigned user

[Former Member]

Hi all,

Is there any table that will show me a list of users assigned to user groups instead of using transaction code SQ03.

I have table AQGDBBN, but it'll only shows Global Area (Cross-client) groups and assigned users,

but I need to see the groups used in Standard Area(Client-Specific) also.

Thanks,

Anuj jain

[former_member1370893]

Hello community, Is there a table or report where I can view a list of user groups and the queries/infosets assigned to the specific user group? I wan to identify what user group has queries assigned to the group and especially if there is a user group which dont have any assigned.

thank you

[michele_williams]

Hello. In general, it's best not to reply to a thread that is as old as this one! But I happened to be searching for the same reason today and found the answer above in this thread. Report RSAQUSGR.

[Former Member]

Thanks thien ,

You Solved my problem for certain limit

Regards,

Anuj jain

[Former Member]

Dear Thien ,

Table AQGDBBG give only user group with created/updated person user id not assigned user in SQ03.

Regards,

Anuj

[Former Member]

Dear Anuj,

Kindly check report RSAQUSGR. It will show you what you want, table AQLDB will store user group assign role but it's a cluster table. You have to find method to read data from it.

hope it helps,

thanks

Edited by: Thien M. Pham on Aug 25, 2010 10:08 AM

[Former Member]

Dear Pauls,

Thanks for Your reply,

I want to extract these details through SAP table, so pls can You give me some ideas abt related tables.

Regards,

Anuj jain

[Former Member]

Hi,

Check table AQGDBBG

regards,

[Former Member]

In all query transactions

Environment->Query areas

))

[Worrell]

Just in case other users are looking for similar information. I just came across this program in SA38 while looking for last execution and usage for SQ01 queries. You can find assigned user to each user group in SQ03 using SA38 and then execute RSAQUSGR. Enter either name or user group to receive the information.