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. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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


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

Browse other questions tagged or ask your own question.