Insight - Accessing Other Schemas With Modified SQL Advanced Conditions
Last updated on FEBRUARY 09, 2014
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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms