Permissions on Views
От | Donald Fraser |
---|---|
Тема | Permissions on Views |
Дата | |
Msg-id | 002501c42865$e78d94c0$1664a8c0@DEMOLITION обсуждение исходный текст |
Ответы |
Re: Permissions on Views
|
Список | 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=20 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 I= NSERT INTO tbl_useracc (id_user, id_cmpy, id_contrib)=20 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 ab= ove group. I didn't have this problem on version 7.3.4 which is what I have upgraded f= rom. Regards Donald Fraser
В списке pgsql-bugs по дате отправления: