Subject | RE: Re: [firebird-support] Reference |
---|---|
Author | Chad Z. Hower |
Post date | 2004-11-28T22:58:24Z |
:: >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? It
only allows the FK to "Exist" in a table that the user selects from? If they
don't have this priv and they select data from a table with an FK to it, it
trips?
Does granting select also "include" references? That is if I grant select,
do I need to grant references too?
:: 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? It
only allows the FK to "Exist" in a table that the user selects from? If they
don't have this priv and they select data from a table with an FK to it, it
trips?
Does granting select also "include" references? That is if I grant select,
do I need to grant references too?