Please let me know how to assign Sav role "ROLE_SAV_MANAGER" by default to all Managers.
Kindly let me know how it can be achieved.
Solved! Go to Solution.
Steps To Follow:
1) Enable SaviyntForSaviynt from Global Configuration:
2) Once SaviyntForSaviynt is configured, we would be using the user import functionality from SaviyntForSaviynt to trigger rules. So, we will have to build a user import XML.
3) Sample XML: A few best practices have been highlighted and explained below:
<sql-query description="This is the Source DB Query" uniquecolumnsascommaseparated="username">
<![CDATA[select username,'Assign Role' as customproperty21 from users where statuskey=1 and costcenter='ABC12' and customproperty21 is null;]]>
<mapper description="This is the mapping field for Saviynt Field name" dateformat="date">
<mapfield saviyntproperty="username" sourceproperty="username" type="character"></mapfield>
<mapfield saviyntproperty="customproperty21" sourceproperty="customproperty21" type="character"></mapfield>
In the sample XML above, a few best practices have been followed:
Apart from the above solution. Could you please let us know how this can be achieved in a different way. We are not getting the Manager flag from our Source of truth.
Please let us know the solution.
If your Authoratative Source is not sending a flag, then the best approach is to utilize the solution provided by Belwyn.
The SQL query that he has used can be written in such a way that it lists only those users who are Managers in Saviynt.