Re: Foreign keys breaks tables permissions

Поиск
Список
Период
Сортировка
От wieck@debis.com (Jan Wieck)
Тема Re: Foreign keys breaks tables permissions
Дата
Msg-id m12fMDN-0003lFC@orion.SAPserv.Hamburg.dsh.de
обсуждение исходный текст
Ответ на Foreign keys breaks tables permissions  (Raul Chirea <raul@brahms.ro>)
Ответы Re: [BUGS] Re: Foreign keys breaks tables permissions  (Peter Eisentraut <peter_e@gmx.net>)
Re: Foreign keys breaks tables permissions  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-sql
>
> Hi,
>
> If one does:
>
> [...]
>  grant select on master to a_user;
>  grant select, insert, update, delete on detail to a_user;
>
> then if login as "a_user" and does:
>
>   insert into detail (id, master_id) values (1, 10);
>
> this will result in: "ERROR:   master: Permission denied".
>
> This seems a bug to me ? Isn't it ?

Outch,
   yes,  we  missed  something  here.  Peter,  you  said  you'll   probably work  on  the  ACL  stuff  after  7.0.  We
need to   coordinate that work with the function manager redesign to go   for SETUID triggers and functions.
 


Jan

--

#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me.                                  #
#========================================= wieck@debis.com (Jan Wieck) #




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

Предыдущее
От: Drew Whittle
Дата:
Сообщение: Re: DBD::ODBC for Linux
Следующее
От: "Kardos, Dr. Andreas"
Дата:
Сообщение: Re: [HACKERS] SQL92 specification ....