Skip site navigation (1) Skip section navigation (2)

PostgreSQL BugTool Submission

From: pgsql-bugs(at)postgresql(dot)org
To: pgsql-bugs(at)postgresql(dot)org
Subject: PostgreSQL BugTool Submission
Date: 2000-08-22 19:36:29
Message-ID: 200008221936.e7MJaTp13369@hub.org (view raw or flat)
Thread:
Lists: pgsql-bugs
James Aspnes (aspnes(at)cs(dot)yale(dot)edu) reports a bug with a severity of 2
The lower the number the more severe it is.

Short Description
checking foreign keys requires write access

Long Description
In version 7.0.2, create tables A and B where B has a foreign
key reference to A.  Grant user X insert access on B but only
select access on A.  Attempts by X to insert into B will fail
with an access error on A, even though X is allowed to read A
(and thus verify that the foreign key constraint is not violated.)[B

Sample Code


No file was uploaded with this report


Responses

pgsql-bugs by date

Next:From: Stephan SzaboDate: 2000-08-22 21:14:16
Subject: Re: PostgreSQL BugTool Submission
Previous:From: roberto_vanonciniDate: 2000-08-22 16:33:38
Subject: HP-Ux v.11 release

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group