Re: Permissions on Views - Mailing list pgsql-bugs

From Tom Lane
Subject Re: Permissions on Views
Date
Msg-id 25559.1082640384@sss.pgh.pa.us
Whole thread Raw
In response to Permissions on Views  ("Donald Fraser" <demolish@cwgsy.net>)
List pgsql-bugs
"Donald Fraser" <demolish@cwgsy.net> writes:
> Now whenever I attempt to INSERT into the view I get the following error.
> ERROR: permission denied for relation vu_tbl_useracc

I tried to reproduce this and couldn't.

> I didn't have this problem on version 7.3.4 which is what I have upgraded f=
> rom.

7.3.4 had some rather serious permission-checking bugs, so the fact that
your code worked in 7.3.4 is no guarantee that it's right.  I'd suggest
rechecking your permissions ...

            regards, tom lane

pgsql-bugs by date:

Previous
From: "Donald Fraser"
Date:
Subject: Permissions on Views
Next
From: "Donald Fraser"
Date:
Subject: Re: Correction to previous post - Permission on views