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

help / color / mirror / Atom feed

From: Eugene E. <sad@bankir.ru>
To: Eugene E. <sad@bankir.ru>
Cc: PFC <lists@peufeu.com>
Cc: Rod Taylor <pg@rbt.ca>
Cc: pgsql-sql@postgresql.org
Subject: Re: Permission to Select -- I am wrong
Date: Tue, 14 Mar 2006 09:10:01 +0300
Message-ID: <44165E39.2000902@bankir.ru> (raw)
In-Reply-To: <44165D76.7070201@bankir.ru>
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>
	<44165D76.7070201@bankir.ru>

Eugene E. wrote:
> 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)

I AM WRONG !
sorry.

Message-ID: <44165E39.2000902@bankir.ru>
Permalink:  ../44165E39.2000902@bankir.ru/
Also on:    postgresql.org/message-id/44165E39.2000902@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 -- I am wrong
  In-Reply-To: <44165E39.2000902@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