How to query Users ad their own Authorization Groups

[daniela_leoni]

SELECT U.USERID , U.USER_CODE, U.U_NAME, G.GROUPID, G.GROUPNAME
FROM OUSR U
LEFT JOIN USR7 U7 ON U7.UserId = U.USERID
LEFT JOIN OUGR G ON U7.GROUPID = G.GROUPID AND G.GroupType = 'A'

[ManishPant]

Could you provide more specific details?

[daniela_leoni]

In SAP B1 you can associate one or more Group to a user. Then you can assign to the Group some authorizations.

All the users having that group inherit the same authorizations.

If you need to know which users belong to a specific group you can use the query above.

Regards

DLE