Re: Cross user FK relationships

Nathan Stiltner wrote:
>
> Hi,
>
> We are trying to establish a relationship between tables belonging to
> two owners in an Oracle 7.1.3 database. No matter what rights the user
> who tries to run the alter script has (i.e. dba, etc.) the database
> comes back with an error saying that it cannot find the table even
> though we fully qualified it (i.e. owner.tablename). Does anyone know
> if this is supported in Oracle?
>
> Thanks in advance for your help!
>
> Nathan Stiltner

It is supported. Did you give the REFERENCES privilege? Check the documentation around this privilege and it should clarify it for you.

Wayne Linton
Shell Canada Ltd. Received on Sat Dec 07 1996 - 00:00:00 CET