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 B699C5284F for ; Tue, 16 Aug 2005 20:17:34 -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 33831-08 for ; Tue, 16 Aug 2005 23:17:30 +0000 (GMT) Received: from hermes.cbasys.net (hermes.cbasys.net [67.43.167.178]) by svr1.postgresql.org (Postfix) with ESMTP id 234DE529FA for ; Tue, 16 Aug 2005 20:17:29 -0300 (ADT) Received: from [192.168.0.108] (unknown [63.170.247.153]) by hermes.cbasys.net (Postfix) with ESMTP id AE940E00B40B for ; Tue, 16 Aug 2005 16:17:33 -0700 (PDT) Message-ID: <4302740D.1020808@cbamedia.com> Date: Tue, 16 Aug 2005 16:17:33 -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=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=-4.072 required=5 tests=[AWL=-0.137, RCVD_IN_BSP_TRUSTED=-4.3, SUBJ_ALL_CAPS=0.365] X-Spam-Level: X-Archive-Number: 200508/205 X-Sequence-Number: 18524 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