Re: Permissions and views.

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(at)unl(dot)edu(dot)ar
Programador, Administrador | Centro de Telematica
Universidad Nacional
del Litoral
-----------------------------------------------------------------