Re: Foreign keys breaks tables permissions - Mailing list pgsql-sql

From wieck@debis.com (Jan Wieck)
Subject Re: Foreign keys breaks tables permissions
Date
Msg-id m12fMDN-0003lFC@orion.SAPserv.Hamburg.dsh.de
Whole thread Raw
In response to Foreign keys breaks tables permissions  (Raul Chirea <raul@brahms.ro>)
Responses Re: [BUGS] Re: Foreign keys breaks tables permissions
Re: Foreign keys breaks tables permissions
List 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 by date:

Previous
From: Drew Whittle
Date:
Subject: Re: DBD::ODBC for Linux
Next
From: "Kardos, Dr. Andreas"
Date:
Subject: Re: [HACKERS] SQL92 specification ....