Skip to main content
Skip table of contents

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 although 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.

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




subset, import, metadata, oracle

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.