To find the USER_ID for the user of interest, run the following query (replace "tibco@example.com" with the user's user name):
Select * from USERS where USER_NAME='tibco@example.com';
This will return the user_id. Copy the GUID and use it in the below query.
Execute the following example query on the TIBCO Spotfire Server application database to find the list of group memberships for a given user (replace "3897ed0d-6729-4938-bae2-872d30a059cc" with the GUID from the above query):
select u.USER_ID,u.USER_NAME, g.DISPLAY_NAME from USERS u
join GROUP_MEMBERS gm on gm.MEMBER_USER_ID = u.USER_ID
join GROUPS g on g.GROUP_ID=gm.GROUP_ID
where USER_ID ='3897ed0d-6729-4938-bae2-872d30a059cc'
Important note:
- The output does not include "Everyone" group.
- The above query is an example tested on Microsoft SQL server.
Disclaimer:
The content of this article is for informational purposes only. The subject material may change in any new versions with no notice and there is no responsibility by TIBCO to maintain or support future access to this internal application content. Modification of any internal application content is not recommended and can lead to an unsupported configuration. It is not intended to be used "As Is" in a Production environment. Always test in a Development environment.