I would like to connect Delphix connectors not directly to Oracle schema owner of the objects
to profile. But I would like to connect to another Oracle schema without tables defined on it and
acting as intermediate schema granted with select privileges on the other Oracle schema owning the
objects to profile. I would like to grant "select_catalog_role" to that intermediate schema to
enable selecting Oracle Catalg for meta-data definitition of objects to profile.
When i connect new rule-set with that connector defined on oracle intermediate schema I get
"No tables found". Is there a solution regards this issue?
Thank you for your availability.
There are some tables on the principal schema that i haven't to profile. But uncheck them from the
list in the rule-set creation wizard seems to take too time and therefore be prone to errors. Since I
haven't to act directly on the schema owning those tables I would like to create an intermediate
schema with select grants only to tables that i have to profile.
And what if i will define on the intermediate schema synonyms only on those tables on the principal schema that i have to profile?
Thank you very much.