X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id EFBFA9DCAA5 for ; Tue, 14 Mar 2006 02:12:45 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 48929-10 for ; Tue, 14 Mar 2006 02:12:45 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from moon.antora.ru (moon.antora.ru [83.222.21.34]) by postgresql.org (Postfix) with ESMTP id D71329DC9F4 for ; Tue, 14 Mar 2006 02:12:43 -0400 (AST) Received: from [217.26.17.26] (helo=[10.0.0.72]) by moon.antora.ru with esmtpsa (TLSv1:DHE-RSA-AES256-SHA:256) (Exim 4.60 (FreeBSD)) (envelope-from ) id 1FJ2ls-000Ns0-BG; Tue, 14 Mar 2006 09:12:40 +0300 Message-ID: <44165E39.2000902@bankir.ru> Date: Tue, 14 Mar 2006 09:10:01 +0300 From: "Eugene E." User-Agent: Mozilla Thunderbird 1.0.2 (X11/20050517) X-Accept-Language: en-us, en MIME-Version: 1.0 To: "Eugene E." CC: PFC , Rod Taylor , pgsql-sql@postgresql.org Subject: Re: Permission to Select -- I am wrong References: <441540AA.3090202@bankir.ru> <1142260392.857.49.camel@home> <20060313144617.GG8274@surnet.cl> <1142262651.857.77.camel@home> <44165D76.7070201@bankir.ru> In-Reply-To: <44165D76.7070201@bankir.ru> Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.12 required=5 tests=[AWL=0.120] X-Spam-Score: 0.12 X-Spam-Level: X-Archive-Number: 200603/216 X-Sequence-Number: 24562 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.