Re: Permissions on Views

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Donald Fraser" <demolish(at)cwgsy(dot)net>
Cc: "[BUGS]" <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: Permissions on Views
Date: 2004-04-22 13:26:24
Message-ID: 25559.1082640384@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

"Donald Fraser" <demolish(at)cwgsy(dot)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

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message JC Jan Christensen 2004-04-22 15:16:42 INITDB-error - end-of-copy marker error
Previous Message Donald Fraser 2004-04-22 13:06:22 Re: Correction to previous post - Permission on views