PostgreSQL BugTool Submission

Поиск
Список
Период
Сортировка
От pgsql-bugs@postgresql.org
Тема PostgreSQL BugTool Submission
Дата
Msg-id 200008221936.e7MJaTp13369@hub.org
обсуждение исходный текст
Ответы Re: PostgreSQL BugTool Submission  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
Список pgsql-bugs
James Aspnes (aspnes@cs.yale.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

В списке pgsql-bugs по дате отправления:

Предыдущее
От: roberto_vanoncini@hp.com
Дата:
Сообщение: HP-Ux v.11 release
Следующее
От: pgsql-bugs@postgresql.org
Дата:
Сообщение: PostgreSQL BugTool Submission