Database User Unable to Query DISCREPANCIES_V on DMW Business Area (Doc ID 2873835.1)

Last updated on JULY 13, 2023

Applies to:

Symptoms

All study access is working properly for a database user in the LSH database. The User has all study access and previously was able to successfully run the below query:

select * from <Business Area Name>.DISCREPANCIES_V;

But the SELECT grant privilege on the <Business Area Name>.DISCREPANCIES_V is now revoked. The query returns the error:

"ORA-00942: table or view does not exist"

The query : select * from dba_tab_privs where table_name = 'DISCREPANCIES_V';

Does not return the Username as a "Grantee". Also manually granting the select privilege on the view to the user does not resolve the problem.

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.