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