Applications Security

Get Involved. Join the Conversation.

Topic

    Kunal Daya
    Report that shows a role and all the duties and privleges it...
    Topic posted April 8, 2019 by Kunal DayaRed Ribbon: 250+ Points, tagged Financials, HCM, Other, Procurement, Project Portfolio Management, Security 
    120 Views, 3 Comments
    Title:
    Report that shows a role and all the duties and privleges it inherits
    Summary:
    Report that shows a role and all the duties and privleges it inherits
    Content:

    Hi All,

    I am trying to build a report that shows roles and what it inherits in terms of data roles, duties and privleges. Does anyone know a report that exists with this information or the tables where this information is stored?

    Comment

     

    • Aarti Satyamurthy

      Check out the customer connect post - https://cloudcustomerconnect.oracle.com/posts/2d991eef2f

      You could also run the delivered "User and Role Access Audit Report". 

      The process produces three files for a role:

      An XML file documenting data security policies for the role
      An XML file documenting functional security policies for the role in hierarchical format
      An XML file documenting functional security policies for the role in tabular format

    • Ivan Martinez

      From the Security Console there is an Analytics option.  When you select that you will see a pie chart which is a breakout of all the roles in Fusion.  You will need to know the Role Category, but once you do you would go to that area. For example, if its an HCM Data Role which you are looking to analyze then, you would click on the HCM - Data Roles hyper link from the role categories table.  Then you will be presented with another table below the role categories which is showing you all the roles that belong to the category you just selected - in this example HCM data roles.  You would then search on that table for the role you are concerned with and then click on the name of the role, it will be a hyper-link.  This will bring up a new page which I believe has everything you are looking for and you can export to excel for analysis.

       

      Regards,

      Ivan

    • Rakesh Lathiya

      try using ASE tables