Re: Grants on rules

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Alberto Cabello Sanchez <alberto(at)unex(dot)es>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Grants on rules
Date: 2004-07-06 13:33:15
Message-ID: 28712.1089120795@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Alberto Cabello Sanchez <alberto(at)unex(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2004-07-06 13:40:03 Re: could not access file "$libdir/plpython" when restoring
Previous Message Markus Wollny 2004-07-06 13:32:59 Re: ./configure --with-java fails