Applications Security

Get Involved. Join the Conversation.

Topic

    Yousif Badawi
    Manage Data Access for Users - Batch Upload
    Topic posted September 29, 2018 by Yousif BadawiRed Ribbon: 250+ Points, tagged Security, Tip 
    432 Views, 8 Comments
    Title:
    Manage Data Access for Users - Batch Upload
    Summary:
    How to use the spreadsheet to give user data access to multiple users at once.
    Content:

    I am struggling with the right way to fill the excel sheet to give many users some data access, is there any video or step-by-step manual with screenshot so that I can understand how I can copy one staff data-access roles to other team in his department, all at once. Thanks!


    Reference:
    Assigning Data Access to Users Using a Spreadsheet:
    https://docs.oracle.com/cloud/farel12/common/FASER/FASER1345798.htm#FASER1345779

    Version:
    R13

    Comment

     

    • Joshua Vincent
      Try exporting user with data access into spreadsheet. Then back out of the manage a data access page, and go back in and click the button to add access that generated the adfdi spreadsheet. Lopen and log into spreadsheet. Count lines of sheet from export file. Highlight first table line of upload spreadsheet and drag down to highlight same number of lines, then right click-->insert to get that number of "smart" rows in upload spreadsheet. Then highlight copy/paste the three non-username columns (not rows) from the export file and paste them into the smart rows you created in the upload file. Note these columns are in a different order from one file to the other! Once those three rows are complete, enter user name in appropriate column and eliminate any unused "smart" rows. Then click upload.
      
      FYI: You will get errors if the user does not have the roles referenced in the upload file.
      
      
      • Yousif Badawi

        Thank you Sir for taking time to reply. I guess this below step is what I need to figure in order to get to this Smart copy. I will try to know how and let you know. Thanks again.

        "Highlight first table line of upload spreadsheet and drag down to highlight same number of lines, then right click-->insert to get that number of "smart" rows in upload spreadsheet. "

         

    • Yousif Badawi

      Dear Mr. Kevin, 

      Thanks a lot for the screenshots, Hopefully this will help me understand how it is done now.

      If I may ask, after this you don't need to go and double-click cell by cell to open the Web UI and select the corresponding *Security Context Value[..] , right? 

      In other words, can you copy the values in Security Context Value[..] columns as well or still you need to pick them one by one manually via the pop-up [Select Security Context Value] web screen?

      Select Security Context Value Screen

      Appreciate your time feedback in advance.