Skip site navigation (1) Skip section navigation (2)

Permissions on Views

From: "Donald Fraser" <demolish(at)cwgsy(dot)net>
To: "[BUGS]" <pgsql-bugs(at)postgresql(dot)org>
Subject: Permissions on Views
Date: 2004-04-22 12:32:40
Message-ID: 002501c42865$e78d94c0$1664a8c0@DEMOLITION (view raw or flat)
Thread:
Lists: pgsql-bugs
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_useracc TO GROUP grp_cisx_admin;

CREATE OR REPLACE RULE rul_i01 AS ON INSERT TO vu_tbl_useracc DO INSTEAD  INSERT INTO tbl_useracc (id_user, id_cmpy, id_contrib) 
  VALUES (new.id_user, new.id_cmpy, new.id_contrib);

Now whenever I attempt to INSERT into the view I get the following error.
ERROR: permission denied for relation vu_tbl_useracc

The error goes away if I grant both INSERT and UPDATE permissions to the above group.

I didn't have this problem on version 7.3.4 which is what I have upgraded from.

Regards
Donald Fraser

Responses

pgsql-bugs by date

Next:From: Donald FraserDate: 2004-04-22 13:06:22
Subject: Re: Correction to previous post - Permission on views
Previous:From: Mike QuinnDate: 2004-04-21 17:52:50
Subject: make check regression "test stats" failed

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group