Oracle Analytics Cloud and Server

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

Provision access to view logs(queries) in OBIEE 12C

Received Response
1
Views
2
Comments
2951778
2951778 Rank 2 - Community Beginner

Hi,

We are running on OBIEE 12.2.1.0. Some of our business teams want access to view logs to extract SQL queries but we could not find any permission that directly gives access to query logs.

All I find is access to Admin which could be giving access to Administration page. Would this let them to view logs or would it let them rewrite the permissions on other objects.

Thanks

AB

Answers

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    Why don't you just expose the S_NQ_ACCT table (maybe plus S_NQ_DB_ACCT) through the normal Usage Tracking Subject Area and people can use it in Answers and Dashboards?

    That's standard functionality.

  • Thomas Dodds
    Thomas Dodds Rank 8 - Analytics Strategist

    Use Usage Tracking ... don't start handing out Admin level anything to users!