Missing Group Value in Postman

[JezzaN]

Hi! I'm trying to get the membership of a specific user in sys_user_grmember table. I can see that the user is added to some groups however, I can't identify them because the value is missing. Is there something I missed during the creation of the groups and adding of the user?

[Tony Chatfield1]

Hi, testing in a PDI using the sysparm_fields values shown in your screenshot I get expected results with admin account. Is this the same result for all records in the table, otherwise it might just be that the underpinning group record has been deleted without the delete cascading to sys_user_grmember?
Does the user you are authenticating with have visibility of sys_user_group table?
Can this user see groups and the grmember group values if they login and browse to the tables directly?

[JezzaN]

Hi @Tony Chatfield1 

Thank you for the response. 

Is this the same result for all records in the table, otherwise it might just be that the underpinning group record has been deleted without the delete cascading to sys_user_grmember? - No other groups added to the user displays its value, while others are not

Does the user you are authenticating with have visibility of sys_user_group table? - Yes. The service account have visibility to the tables sys_user, sys_user_group, and sys_user_grmember.

Can this user see groups and the grmember group values if they login and browse to the tables directly? - Nope. the user does not have any role in it. 

Is there any way that I can add any groups to the user without having the admin role to the service account?

[Tony Chatfield1]

Hi, it should not be necessary for a web-services account to have 'admin' role and testing in a PDI using a webservices only user account, I am not able to reproduce your issue; which suggests it might be the result of local customization? Have any customizations\changes been made to sys_user_grmember or sys_user_group ACL's or QBR's?

What release\patch is your instance running?

[Tony Chatfield1]

Also, do you see a difference in behavior if your remove the sysparm_fields and\or any other optional parameters?