pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  

help / color / mirror / Atom feed

From: Eugene E. <sad@bankir.ru>
To: PFC <lists@peufeu.com>
Cc: Rod Taylor <pg@rbt.ca>
Cc: pgsql-sql@postgresql.org
Subject: Re: Permission to Select
Date: Tue, 14 Mar 2006 09:06:46 +0300
Message-ID: <44165D76.7070201@bankir.ru> (raw)
In-Reply-To: <op.s6ddkgyncigqcu@apollo13>
References: <Pine.LNX.4.44.0507280919020.4325-100000@matrix.gatewaynet.com>
	<441540AA.3090202@bankir.ru>
	<1142260392.857.49.camel@home>
	<20060313144617.GG8274@surnet.cl>
	<1142262651.857.77.camel@home>
	<op.s6ddkgyncigqcu@apollo13>

PFC wrote:
> 
> 
>> What information can be retrieved from a structure by being able to
>> update all rows?
> 
> 
>     Write a plpgsql function snoop(x) which inserts x into a table 
> 'log'  created by you, and also returns x.
>     UPDATE users SET password=snoop(password).
>     Read log table.
>     Done.

This trick is available _NOW_.
(in the current state of permission system)

view thread (10+ messages)  latest in thread

Message-ID: <44165D76.7070201@bankir.ru>
Permalink:  ../44165D76.7070201@bankir.ru/
Also on:    postgresql.org/message-id/44165D76.7070201@bankir.ru

copy link · copy postgr.es

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: sad@bankir.ru, lists@peufeu.com, pg@rbt.ca
  Subject: Re: Permission to Select
  In-Reply-To: <44165D76.7070201@bankir.ru>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox