Does anyone know how I would determine which group each user is assigned to in BSM 9.23?
If I use TopazBrowser tool, I can see the group definitions in the group_auth table... but I still do not know how to map each user into what group they are assigned to.
Is there a way to determine what group each of my users in BSM are assigned to? Maybe a sql statement or quiery?
Any information greatly appreciated.
did you try looking at the UI??
in Users Management select the user and click on the "Hierarchy" tab on the right side.
I do see the group assignments in the BSM UI under USer Management, but Is there a query I can run to get this same information from the database?
Any info appreciated.
you can look at USERS table in the MNG DB.
i dont know if we keep this assignment info in the DB and in which table.