My Oracle Support Banner

Insight - Accessing Other Schemas With Modified SQL Advanced Conditions (Doc ID 1619217.1)

Last updated on SEPTEMBER 20, 2019

Applies to:

Oracle Argus Insight - Version 7.0.2 and later
Information in this document applies to any platform.


In Insight we often create advanced conditions with modified SQL. When we do this we need to query custom tables or views in schemas other than APR_MART. What grant rights are needed in these other schema to enable Insight to do this?

 If we grant select to public this works, but poses a security risk. Please advise what grants are needed specifically.

If grants are insufficient an SQL error is given when the advanced condition is executed.


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.