How to create a report/Analysis in OTBI to have details with respect to Security Audit?

Question

I need to create report with fields listed as below:

User Name, User Email, Role Name, Role Provisioned date, Role provisioned by

What are the steps/Subject areas/ SQL?

Hassan El Bouihi-Oracle · Answer

Hi Naresh,

You can use this seeded report to get this information.

Please run the "User and Role Access Audit Report" ESS Job with the similar parameters

Report Type: User Name

User Name: User with the issue

Data Security Policies checked

Thank you

Hassan

Naresh Enugonda · Answer

Thank you Hassan. This document didn't help with the ask.

I wanted to create a report with below fields:

User ID| User Name | ROLE NAME | Role Provisioned by | Role Provisioned Date

Hassan El Bouihi-Oracle · Answer

Hello Naresh,

If you are part of the SaaS customers, you may use the Security - Roles and Privileges Real Time subject area.

Please refer to KM Note:

Cross Subject Area based on Security - Roles and Privileges Real Time Not Filtering For Line Manager (Doc ID 2777660.1)

Thank you

Hassan