Hello.
I have One Identity 8.1.4. I need to display all user roles on the web portal with Active Directory groups.
In SchemaExtension.exe, I created a new view with an SQL query:
select O.UID_Org As UID_Org, pio.UID_Person As UID_Person, ag.UID_ADSGroup AS UID_ADSGroup from PersonInOrg pio join Org O on pio.UID_Org = o.UID_Org LEFT OUTER join OrgHasADSGroup oha on o.UID_Org = oha.UID_Org LEFT OUTER join ADSGroup ag on oha.UID_ADSGroup = ag.UID_ADSGroup
View name: PersonInOrgWithGroup
I created a new module in the Web Designer, in the collection I added PersonInOrgWithGroup, in the WHERE clause I specified sqlcompareuid ("UID_Person", GetUser ()). In the Form, I created a Grid with fields from PersonInOrgWithGroup..
When going to the module on the web portal, I get the error: Object of type PersonInOrgWithGroup does not exist in database or you do not have the relevant viewing permissions.
In Designer, I have granted view permissions for groups: VI_4_ALLUSERS and VI_4_ALLUSERS_LOOKUP. The tables PersonInOrg, OrgHasADSGroup, Org, Person are available for viewing for all users.
How to show information on roles and groups for users on the portal?