Received: from localhost (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 6E4A264FCB1 for ; Mon, 17 Nov 2008 11:06:18 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 77256-10 for ; Mon, 17 Nov 2008 11:06:14 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from n4a.bullet.mail.ac4.yahoo.com (n4a.bullet.mail.ac4.yahoo.com [76.13.13.67]) by mail.postgresql.org (Postfix) with SMTP id C6FB864FC5C for ; Mon, 17 Nov 2008 11:06:14 -0400 (AST) Received: from [76.13.13.25] by n4.bullet.mail.ac4.yahoo.com with NNFMP; 17 Nov 2008 15:06:13 -0000 Received: from [76.13.10.168] by t4.bullet.mail.ac4.yahoo.com with NNFMP; 17 Nov 2008 15:06:13 -0000 Received: from [127.0.0.1] by omp109.mail.ac4.yahoo.com with NNFMP; 17 Nov 2008 15:06:13 -0000 X-Yahoo-Newman-Property: ymail-3 X-Yahoo-Newman-Id: 262839.20601.bm@omp109.mail.ac4.yahoo.com Received: (qmail 37336 invoked by uid 60001); 17 Nov 2008 14:51:30 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=X-YMail-OSG:Received:X-Mailer:Date:From:Reply-To:Subject:To:In-Reply-To:MIME-Version:Content-Type:Message-ID; b=X/PGKdQecqZQ9Odo8kRyr8eF9Pqz8Ina08iC07FiGp4LjIi70CsAIIbnnhHWaEdU23bcIR4WBR6pASulqmHW4Hpk9dUXJ/pthpn4JaknqDAaFsg6uaa3xrKK/yG4KykQxcCgFyMvXfSBA1mYEHzPg+RAho3tMTVGVOc6KMIgYgQ=; X-YMail-OSG: x.XiK_kVM1kSUd7dh0ydp3flkIvkDmMXA0nPZZVmgtdXPnPO1MzK.M8Ifpegxec0nophEabJg0puptbai_5el_vM6IgS49VlDlgd2P6piFHrlQhgJwBptEFi7uRIis3AoXE_2griHgWNUiut1LoVyBn9ovpf Received: from [161.196.9.65] by web59511.mail.ac4.yahoo.com via HTTP; Mon, 17 Nov 2008 06:51:29 PST X-Mailer: YahooMailWebService/0.7.260.1 Date: Mon, 17 Nov 2008 06:51:29 -0800 (PST) From: Lennin Caro Reply-To: lennin.caro@yahoo.com Subject: Re: ERROR To: pgsql-general@postgresql.org, Gustavo Rosso In-Reply-To: <492188D2.2050805@sadaic.org.ar> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Message-ID: <142281.37223.qm@web59511.mail.ac4.yahoo.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200811/731 X-Sequence-Number: 140449 > From: Gustavo Rosso > Subject: [GENERAL] ERROR > To: pgsql-general@postgresql.org > Date: Monday, November 17, 2008, 3:08 PM > I create a db wiht user postgres, but other users can't > no create tables, and I give all privileges. > > (banco is my db) > > grant all on database banco to public; > grant create on database banco to public; > > This is the error: > *ERROR: must be owner of relation (table)* > Help me!!! > alter table table_name owner to public the public rol must exist