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

Last updated on JULY 13, 2023

Applies to:

Goal

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.
 

Solution

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