Received: from mailbox.orfinet.cz (mailbox.orfinet.cz [195.119.181.60]) by hub.org (8.9.3/8.9.3) with ESMTP id PAA09383 for ; Wed, 2 Jun 1999 15:12:25 -0400 (EDT) (envelope-from davids@orfinet.cz) Received: from chameleon. (p15.rk3.orfinet.cz [195.119.181.30]) by mailbox.orfinet.cz (8.8.5/8.8.5) with ESMTP id VAA01368 for ; Wed, 2 Jun 1999 21:15:34 +0200 Received: (from david@localhost) by chameleon. (8.9.3/8.9.3) id VAA26638; Wed, 2 Jun 1999 21:10:16 +0200 To: pgsql-sql@postgresql.org Subject: how to delete access rights from non-existent user ? From: David Sauer Date: 02 Jun 1999 21:10:04 +0200 Message-ID: Lines: 40 User-Agent: Gnus/5.070084 (Pterodactyl Gnus v0.84) XEmacs/21.1 (20 Minutes to Nikko) MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Hello, Now, the problem: (current CVS snapshot) Suppose, we have user "test" (uid=1000), which has some rights on some table. Ex.: Database = david +----------+-----------------------------+ | Relation | Grant/Revoke Permissions | +----------+-----------------------------+ | t | {"=","postgres=a","test=a"} | +----------+-----------------------------+ Now, I delete user "test" from database: david=> drop user test; DROP USER david=> \z Database = david +----------+-----------------------------+ | Relation | Grant/Revoke Permissions | +----------+-----------------------------+ | t | {"=","postgres=a","1000=a"} | +----------+-----------------------------+ david=> revoke all on t from 1000; ERROR: parser: parse error at or near "1000" david=> revoke all on t from '1000'; ERROR: parser: parse error at or near "'" david=> revoke all on t from "1000"; ERROR: aclparse: non-existent user "1000" Is there way, how to revoke rights from user with uid = 1000 ? I can create new user with uid = 1000, then revoke rights and drop user, but this is too complex for me ... thanks for any help, -- * David Sauer, student of Czech Technical University * electronic mail: davids@orfinet.cz (mime compatible)