At 01:42 AM 28/11/2004 +0100, Bas wrote:

>| In the grant options, what does reference mean? Ive read the
>| docs a dozen times, but I don't undersand how it differs from select.
>
>I think it means you can execute objects ( eg. Views ) that reference the
>table, so you might not have access to do a select on the table, but you
>might have access to do select on views that reference that table ( the view
>cout filter records )

No, this is not correct.

Depending on ownership, specific access privileges must be granted to users
and/or to objects (such as views and stored procedures) that require access
to tables and other dependent objects. This is quite different to the
REFERENCES privilege, although REFERENCES privileges might well be required
by views because of foreign key constraints in the tables used by
them. See my previous posting.

./heLen