Re: Permissions for foreign keys - Mailing list pgsql-sql

From Ross J. Reedstrom
Subject Re: Permissions for foreign keys
Date
Msg-id 20010131095024.A16818@rice.edu
Whole thread Raw
In response to Re: Permissions for foreign keys  (Najm Hashmi <najm@mondo-live.com>)
List pgsql-sql
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


pgsql-sql by date:

Previous
From: Mark Volpe
Date:
Subject: Re: Permissions for foreign keys
Next
From: Michael Davis
Date:
Subject: RE: no value for numeric filed in SQL statement causes an error