Re: [GENERAL] Grants on rules

2004-07-06 Thread Tom Lane
Alberto Cabello Sanchez <[EMAIL PROTECTED]> writes: > I can GRANT or REVOKE privileges (SELECT, INSERT and so on) on my_view > and my_table, but insert into my_view is always allowed, even for users > that haven't SELECT or INSERT privileges neither on my_table or my_view. I think there was a bug

[GENERAL] Grants on rules

2004-07-06 Thread Alberto Cabello Sanchez
Hi all, I am trying to mimic a table's behaviour on a view thru rules. More precisely, I have a table (say, my_table(field1,field2)) and a view (my_view as select my_field from my_table). For allowing inserts into the view, I have create a rule on "insert into my_view" doing instead insert into my