Re: Permissions for foreign keys

This is a bug that was fixed in 7.1beta for sure, but also 7.0.3,
I believe. So it's as simple as upgrading. 


Ross


On Thu, Feb 01, 2001 at 10:09:29AM -0500, Najm Hashmi wrote:
> Hey Rick,
>          I am sure there are more elegant solutions but I have a simple
> one. Write a trigger that  will grant the permissions  before insert or
> update and and revoke all privileges after the insert or update.
> -Najm
> 
> 
> Rick Delaney wrote:
> 
> > I'm using 7.0 and have noticed that I need to grant SELECT and UPDATE
> > permissions on any referentially-related tables.  Can/should I get
> > around this?  A somewhat contrived example:
> >
-- 
Ross J. Reedstrom, Ph.D., <reedstrm@rice.edu> 
NSBRI Research Scientist/Programmer
Computer and Information Technology Institute
Rice University, 6100 S. Main St.,  Houston, TX 77005