Makes your life easy to do the initial security setup for different teams where you are have to create multiple users, roles and grant them these roles. Or there could be scenario where you have to create multiple end users during UAT or SIT to test if your BO reports using these user id’s see only the data what they are intended to look at. Hope this helps.
I don’t see any script , pls check it up once.
Regards,
Sharath
Sorry, now you can do the download of the spreadsheet from the attached link where I have added the formulas. You can do the customization as per your requirement and generate the SQL’s.
Thanks – this will help.
Sonni