X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id DF827528F9 for ; Tue, 16 Aug 2005 20:07:51 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 31245-10 for ; Tue, 16 Aug 2005 23:07:49 +0000 (GMT) Received: from hermes.cbasys.net (hermes.cbasys.net [67.43.167.178]) by svr1.postgresql.org (Postfix) with ESMTP id 66EB1528D4 for ; Tue, 16 Aug 2005 20:07:49 -0300 (ADT) Received: from [192.168.0.108] (unknown [63.170.247.153]) by hermes.cbasys.net (Postfix) with ESMTP id DEC50E00B444 for ; Tue, 16 Aug 2005 16:07:52 -0700 (PDT) Message-ID: <430271C8.8030909@cbamedia.com> Date: Tue, 16 Aug 2005 16:07:52 -0700 From: Andrew Gold User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.7.8) Gecko/20050513 Debian/1.7.8-1 X-Accept-Language: en MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: GRANT ALL PRIVILEGES ON DATABASE Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=-4.117 required=5 tests=[AWL=-0.182, RCVD_IN_BSP_TRUSTED=-4.3, SUBJ_ALL_CAPS=0.365] X-Spam-Level: X-Archive-Number: 200508/206 X-Sequence-Number: 18525 Hi everyone, I'm sure there's an easy answer for this question, but I confess the situation puzzles me. I have database "example1." I have example1 owner user "user1." user1 is not a super user. I have superuser "su1." su1 creates table "lookatme" in example1. su1 now realizes that he wants to give control of table lookatme and a number of other tables (all of them) to user1, so he executes the following sql: GRANT ALL PRIVILEGES ON DATABASE example1 TO user1. user1 now executes the following sql: SELECT * FROM lookatme; The response is: ERROR: permission denied for relation lookatme Obviously, I can write a script to iterate through all the tables, but what exactly does "GRANT ALL PRIVILEGES ON DATABASE XXX" do if it doesn't even grant basic access? Any insight on the subject is welcome. Thanks, Andrew Gold