At 05:58 PM 28/11/2004 -0500, you wrote:

>:: >The name of the privilege is REFERENCES. It's required if
>:: the table to
>:: >which you are granting any other privileges has a foreign key to
>:: >another table to which the user does not have privileges.
>:: You grant
>:: >the REFERENCES on the table that is referred to by
>:: REFERENCES in the foreign key constraint.
>
>Ok - but this doesn't allow the user to select data via tha FK right?

No. You have to explicitly grant SELECT (and other rights) to a table.

>It only allows the FK to "Exist" in a table that the user selects from?

Yes.

>If they don't have this priv and they select data from a table with an FK
>to it, it
>trips?

Yes.

>Does granting select also "include" references?

No.

>That is if I grant select, do I need to grant references too?

Yes, if the user has not acquired any other privileges to the referenced table.

./hb