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.

HANA_Security_Mass Activity_SQL Script.xlsx – Google Drive

To report this post you need to login first.

3 Comments

You must be Logged on to comment or reply to a post.

    1. Sandeep Hanumaihgari Post author

      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.

      (0) 

Leave a Reply