DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: schema's in Oracle 8

  1. #1
    Join Date
    Apr 2001
    Location
    Montana
    Posts
    1

    Question

    Is there a way to test integrity constraints between a table in your schema and a table in someone else's schema(that you have select, insert, update and delete privileges on)? I tried to create a constraint between a table in my schema and a table in someone else's schema and I got an insufficient privileges error.
    Is there a privilege that we can set for developers to allow them to create constraints accross schema's with out giving them all the alter table privilege?


  2. #2
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    If the parent table in foreign key constraint is not in your own schema you have to have REFERENCES privilege on that table granted by it's owner. Unfortunately there is no appropriate system privilege for that (something like REFERENCES ANY TABLE), so you have to get REFERENCES privilege directly from that user for each table you want to referenc in your FK constraints. BTW, REFERENCES privilege can be limited on a particular column(s) if the owner does not want to grant it on a whole table.
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width