Want to create user profile automatically with 5 roles when user is hired using Database trigger
Why I want to user trigger :
We have HR, FIN, EPM peoplesoft and there are third part application. I can control logic of each appllication throgh trigger better than going throug peopleSoft. If I have to write trigger on which table I should write trigger - PS_PERSON_DATA or PS_JOB.
Purpose if to create user profile with basic roles so that user can sign in in each application. Systems are not fully integrated and it takes lot of time for security person to create profile in each system.