Re: Foreign Key to table in other schema?

Martijn, you can find information of the References privilege that Daniel pointed out in the Concepts manual chapter on constraints and in the SQL manual.

The References privilege allows user B to impose a restriction on the table owner, A, and is required for B to be able to stop user A from deleting rows from their own table. So user A must grant references to user B.

HTH -- Mark D Powell -- Received on Wed Aug 24 2005 - 12:12:29 CDT