I miss a schema in my list of Target schemas in Subset using Oracle, can I fix it?

Situation

In Subset for Oracle you have a Source and a Target user.

The Target user retrieves  a list of Target schemas to use in your mapping.

Sometimes it might happen that the schema you want to use does not appear in the list althoughh you "know" you have permissions for it.

Can I fix it?


Explanation

Yes.

Permissions are quit often a source of brain teasers.

Subset reads the ALL_USER_PRIVS view to obtain a list of schemas.

Sometimes this view does not provide all "permitted" schemas.

A good fix for this is to grant explicit select permissions on just one of the tables in the target schema.

GRANT SELECT ON <SCHEMA>.<TABLE> to <DATPROF_USER>




subset, import, metadata, oracle