Re: Grants on rules - Mailing list pgsql-general

From Tom Lane
Subject Re: Grants on rules
Date
Msg-id 28712.1089120795@sss.pgh.pa.us
Whole thread Raw
In response to Grants on rules  (Alberto Cabello Sanchez <alberto@unex.es>)
List pgsql-general
Alberto Cabello Sanchez <alberto@unex.es> 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 of this ilk between 7.3.3 and 7.3.5, and
possibly also in some of the 7.4 releases.  If that's what you're using,
update to 7.3.6 or 7.4.3.

            regards, tom lane

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Bug in function to_char() !!
Next
From: "Markus Wollny"
Date:
Subject: Re: ./configure --with-java fails