Skip to main content
Skip table of contents

ORA-31603: object "FK_TAB2_TAB1" of type REF_CONSTRAINT not found in schema "USER1"

Situation

I Use Privacy and run it using an Oracle database

I get the error:

[DDL retrieval for foreignkey USER1.FK_TAB2_TAB1] 
ORA-31603: object "FK_TAB2_TAB1" of type REF_CONSTRAINT not found in schema "USER1"

Explanation

Privacy and Subset requires the SELECT_CATALOG_ROLE permission when reading the objects of another schema.

To repair logon as user qith SYS permissions:

grant SELECT_CATALOG_ROLE to USER1



JavaScript errors detected

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

If this problem persists, please contact our support.