Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Privilege for creating PK-FK relationship
Hi Stjepan,
Check out the References object privilege.
Cheers
Richard
"Stjepan Brbot" <stjepan.brbot_at_zg.hinet.hr> wrote in message
news:ahvekj$cjcm$2_at_as201.hinet.hr...
> I'd like to create PK-FK relationship between two tables from different
> schemas. If parent table is in my own schema and child table in another
> schema, what kind of privileges (minimal) I have to have on this child
> table in another schema to create mentioned relationship?
>
> --
>
> Stjepan Brbot
>
>
>
Received on Sat Jul 27 2002 - 22:13:13 CDT