| From: | "Ross J(dot) Reedstrom" <reedstrm(at)rice(dot)edu> |
|---|---|
| To: | Najm Hashmi <najm(at)mondo-live(dot)com> |
| Cc: | Rick Delaney <rick(at)consumercontact(dot)com>, pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: Permissions for foreign keys |
| Date: | 2001-01-31 15:50:24 |
| Message-ID: | 20010131095024.A16818@rice.edu |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(at)rice(dot)edu>
NSBRI Research Scientist/Programmer
Computer and Information Technology Institute
Rice University, 6100 S. Main St., Houston, TX 77005
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Michael Davis | 2001-01-31 16:20:56 | RE: no value for numeric filed in SQL statement causes an error |
| Previous Message | Mark Volpe | 2001-01-31 15:42:59 | Re: Permissions for foreign keys |