Re: Permission to Select - Mailing list pgsql-sql

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)