Received: from woody.aiinet.com (mail1.aiinet.com [38.195.69.30]) by hub.org (8.10.1/8.10.1) with ESMTP id e95LAIJ61788 for ; Thu, 5 Oct 2000 17:10:18 -0400 (EDT) Received: by mail2.aiinet.com with Internet Mail Service (5.5.2650.21) id ; Thu, 5 Oct 2000 17:13:00 -0400 Message-ID: <7283DE19D141D111AD0E00A0C95B195503A59E73@mail2.aiinet.com> From: "Saltsgaver, Scott" To: "'pgsql-sql@postgresql.org'" Subject: Granting of permissions on tables Date: Thu, 5 Oct 2000 17:12:54 -0400 MIME-Version: 1.0 X-Mailer: Internet Mail Service (5.5.2650.21) Content-Type: text/plain; charset="iso-8859-1" X-Archive-Number: 200010/70 I have PostgreSQL v7.02 running on a HP-UX 11.00 box. I as the owner of some tables granted permissions to another user. I executed the following command from psql GRANT ALL on to ; after running the command I lost permissions to the tables once I exited psql. I had to run psql as the postgres user to correct the situation. Is this a bug or desired behavior? I would imagine since I owned the tables and then granted permissions to another user, I wouldn't lose my permissions. Any help or explanation would be appreciated. Thanks, Scott Saltsgaver