- You must be logged in to reply to this topic.
Is there a way to see in a list form a list of all users and their associated access levels ?
Probably not 100% of what you want, but this is at least something to begin with:
declare @RoleID as nvarchar(255) = 'Normal' select r.id as 'Role', 'User' as 'Type', u.id as 'ID' from Pob_Role r left join User_Pob_Role ur on r.pob_role_pk=ur.pob_role_pk left join User_Table u on ur.user_pk=u.user_pk where u.delete_date is null and r.id = @RoleID union all select r.id as 'Role', 'User Group' as 'Type', ug.id as 'ID' from Pob_Role r left join User_Group_Pob_Role ugr on r.pob_role_pk=ugr.pob_role_pk left join User_Group ug on ugr.user_Group_pk=ug.user_group_pk where ug.delete_date is null and r.id = @RoleID order by 2,3
It allows you to see all users and user groups that are assigned to role @RoleID. You can modify the statement to show you all combinations of users, groups and roles together, and with tools like Excel Pivot or Power BI, you can create fancy charts to see who can do what.
Still anything missing?
Hey Stefan, thanks for this. I have no coding experience, can you pls tell me where I should enter this.
Do you have a SQL Management Studio installation anywhere? Maybe you have a DB admin who can support you. The code above is simple SQL, you just need to run it against your POB DB. There may be a chance to get such information using POB Explorers, but I didn’t try that and don’t have anything at hand right now.
The Wendia North American team is excited to announce a new virtual POB Administrator training taking place in November. The training includes remote instruction sessions and daily assigned labs with a mentor available if needed. The first week of training will be the week of November 16th, and the second week will be the week […]
Join our October webinar by Wendia North America senior POB consultant Payton Regan if you would like to learn more about building and utilizing Explorers in POB. Participating in the one-hour webinar that will be held on Tuesday, October 20th, at 16:30 CET / 8:30 am MST, is as always free of charge. See more […]
Join Wendia’s next webinar to learn more about using, maintaining and setting up knowledge. On September 15th, Stephen Goertzen, Wendia North America Senior Consulting Engineer, will host a one-hour webinar on Knowledge Management, where he will approach Knowledge from three different perspectives: Knowledge management for end-users/customers Knowledge management for users Knowledge management in general – setup […]