Dynamic role condition

What version are you using? I've tested your where-clause and it works fine in my environment.

You will find some samples in the documentation ( https://support.oneidentity.com/technical-documents/identity-manager/9.2.1/identity-management-base-module-administration-guide/6#TOPIC-2205772 )

Hi Gary,

To be clear, did you put in the exact statement above? Because generally you select the table the dynamic role is applying on in the 'selection boxes' and then only enter the 'where' part of the query.

Also you'll want to specify what table the uid_person in your sub condition is being drawn from (THe ads account).

So try,

UID_Person in (select a.uid_person from ADSAccount a)