Oracle Transactional Business Intelligence Forum

Home› Oracle Analytics and AI› Oracle Analytics and AI Forums› More Solutions› Oracle Transactional Business Intelligence Forum

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

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

Received Response
41
Views
3
Comments
Naresh Enugonda
Naresh Enugonda Rank 1 - Community Starter
edited Mar 26, 2024 3:20PM in Oracle Transactional Business Intelligence Forum

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?

Tagged:

Answers

  • Hassan El Bouihi-Oracle
    Hassan El Bouihi-Oracle Rank 6 - Analytics & AI Lead

    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

  • Naresh Enugonda
    Naresh Enugonda Rank 1 - Community Starter

    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
    Hassan El Bouihi-Oracle Rank 6 - Analytics & AI Lead

    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