"Donald Fraser" <[EMAIL PROTECTED]> 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=
> r
PostgreSQL 7.4.2 on i386-redhat-linux-gnu, compiled by GCC 2.96
I have a simple VIEW such as the
following:
CREATE OR REPLACE VIEW vu_tbl_useracc AS
SELECT ua.id_user, ua.id_cmpy, ua.id_contrib, ua.dt_edited,
ua.id_editedby FROM tbl_useracc ua;
GRANT SELECT, INSERT ON TABLE vu_tbl_usera
