Pete Finnigan's Oracle Security Forum


    
      
        Pete Finnigan's Oracle Security Forum
        (http://www.petefinnigan.com/forum/yabb/YaBB.cgi)
      

        Oracle Security >> Oracle Auditing >> Oracle User Audit Report 
        
(Message started by: Pete Finnigan on Jan 20^th, 2011, 1:01pm)

Title: Oracle User Audit Report
Post by Pete Finnigan on Jan 20^th, 2011, 1:01pm

Does anyone know how to get a report or sql code that will show all users responsibilities and access they have withing Oracle EBusiness suite
Ebusiness R12 on a 10G database

We have been asked by our Audit team for a full list of all users and there responsibilities and forms they have access to.
Also being new to Oracle as a company they would like definitions for example receipts = enter and find a receipt. This I can see is unreasonable but we must be able to supply the below.

They would like to see the ebusiness navigation front screen as you log in and click on a responsibility to show all forms and webpages in a report

An example would be for myself

Applications Diagnositics
Diagnose
View Reports
Configure

I can get the Applications Diagnostics through sql but can not get to the next level to show what is within the Applications Diagnostics for a user e.g.
Diagnose
View Reports
Configure