Rules and permissions on 7.1.2 (bug)

From: Martín Marqués <martin(at)bugs(dot)unl(dot)edu(dot)ar>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Rules and permissions on 7.1.2 (bug)
Date: 2001-06-07 13:56:29
Message-ID: 01060716563000.14726@bugs
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

OK, I think I found a bug related with privileges, views and rules.

I have a bunch of tables, owned by martin, and some views with the related
rules for inserts, updates and deletes, all owned by martin.

I also have some other users that are in a group webunl_admin. This group is
granted full access (ALL) to the views I mentioned above.

When a user from that group tries to insert data to the view he gets an error
saying that he can't execute nextval('carrera_id_curso_seq').

Now, the manuales say that the rules are executed with the privileges of the
owner of the view and not the user that is executing the query on the view.
So why isn't this working?

Should I fill a bug report?

Saludos.... :-)

P.D.: If you need some output, feel free to ask for it.

--
Cualquiera administra un NT.
Ese es el problema, que cualquiera administre.
-----------------------------------------------------------------
Martin Marques | mmarques(at)unl(dot)edu(dot)ar
Programador, Administrador | Centro de Telematica
Universidad Nacional
del Litoral
-----------------------------------------------------------------

Browse pgsql-hackers by date

  From Date Subject
Next Message Peter Eisentraut 2001-06-07 14:16:33 Re: Re: [PATCHES] Fw: Isn't pg_statistic a security hole - Solution Proposal
Previous Message D. Hageman 2001-06-07 13:50:14 Re: Any time estimates for 7.1.2 RPM's ?