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

Question

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

Thomas Dodds · Answer

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

[Deleted User] · Answer

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.