My Oracle Support Banner

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

Last updated on DECEMBER 29, 2022

Applies to:

Oracle Health Sciences Data Management Workbench - Version 3.1.0 to 3.1.0 [Release 3.1.0]
Information in this document applies to any platform.


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.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

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