Assign Roles to Users based on PSQUERY (Peoplesoft)

Roles to Users based on PSQUERY 

(Peoplesoft)

Step 1

Create a Psquery for user list (Eg: I am selecting the Users whose name starts with 1218_D)

and save that query Type as Role and make as public.

Step 2

open the role which we want, i am opening the role (EXAMPLE_ROLE) and go to dynamic members tab and check the check box Query Rule Enabled & give the Query Name

and click the execute rule and click ok 

then it will trigger the process  DYNROLE_PUBL

 after it went success role assignment is done

We can check the users in SQL Developer