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
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

  • 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.

  • Rank 8 - Analytics Strategist

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

Welcome!

It looks like you're new here. Sign in or register to get started.