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