Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

Using Oracle database, suppose I have a parent table parent defined in schema A, and a child table child defined in schema B. To achieve this, schema A granted references privilege on parent to schema B.

Now, suppose I want to disable all foreign key constraints which reference parent, then I encounter the following issue: since child is in a different schema and schema A has no select privilege on child, child's foreign key which references parent does not appear in schema A's view of all_constraints and so schema A does not know to disable it.

Is there a way to work around this within schema A or must such a program be run with DBA privileges?

share|improve this question

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.