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
-----------------------------------------------------------------