Re: Permissions and views. - Mailing list pgsql-general

From Martín Marqués
Subject Re: Permissions and views.
Date
Msg-id 01050708553000.17471@bugs
Whole thread Raw
In response to Re: Permissions and views.  (Dariusz Pietrzak <dariush@ajax.umcs.lublin.pl>)
Responses Re: Permissions and views.  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
On Lun 07 May 2001 11:29, you wrote:
> > What PG version is this?
>
> 7.0.2
>
> It is said that RULES are executed with rule's owner permissions, so how
> is it possible that different users are getting different results?

This is not true. Rules are not executed with owner permission. The
permission needed is over the relation on which the
SELECT/INSERT/DELETE/UPDATE has been executed.

An example: If you have permission to read (SELECT) on a table, the rule over
that table, ON select will be executed, else NOT.

Saludos... :-)

P.D.: Check views and rules for more info.


--
El mejor sistema operativo es aquel que te da de comer.
Cuida tu dieta.
-----------------------------------------------------------------
Martin Marques                  |        mmarques@unl.edu.ar
Programador, Administrador      |       Centro de Telematica
                       Universidad Nacional
                            del Litoral
-----------------------------------------------------------------

pgsql-general by date:

Previous
From: "AV"
Date:
Subject: Re: Thread or not threads?
Next
From: Tatsuo Ishii
Date:
Subject: Re: v7.1.1 Branched, Packaged and Released ...