Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 53BA69F9ECF for ; Thu, 30 Nov 2006 16:24:57 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-new, port 10024) with ESMTP id 64794-10 for ; Thu, 30 Nov 2006 16:24:49 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 Received: from nf-out-0910.google.com (nf-out-0910.google.com [64.233.182.190]) by postgresql.org (Postfix) with ESMTP id 7C3EF9F9312 for ; Thu, 30 Nov 2006 16:24:51 -0400 (AST) Received: by nf-out-0910.google.com with SMTP id x4so3437265nfb for ; Thu, 30 Nov 2006 12:24:50 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=n523EDDQ1R3tYhbXuD+OA+lMfzeG7CouhtI6S+FvPnn5gQLNGofuGCIbchNMpzMSYjV9HctN491Kc3OgU6dfrtzBzzLzHpgA30BMAjzTnEKnDoGRQRvyrX9E6R/kZCtNj2Q+yX5b86wH9kQMYKorl7m2HXWzsKK4xyiiiSng7eI= Received: by 10.82.129.8 with SMTP id b8mr896725bud.1164918289643; Thu, 30 Nov 2006 12:24:49 -0800 (PST) Received: by 10.82.161.3 with HTTP; Thu, 30 Nov 2006 12:24:49 -0800 (PST) Message-ID: <1f30b80c0611301224r135849ffg2426291a42afa29@mail.gmail.com> Date: Fri, 1 Dec 2006 01:24:49 +0500 From: imad To: "Ezequias Rodrigues da Rocha" Subject: Re: [SQL] Grants Cc: Pgadmin-Support , pgsql-sql@postgresql.org In-Reply-To: <55c095e90611301141n16b8f278n43f65ce5613e663d@mail.gmail.com> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <55c095e90611301141n16b8f278n43f65ce5613e663d@mail.gmail.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200611/244 X-Sequence-Number: 6260 You did not grant access privileges to schema. Also GRANT administrators on the base schema as you did for the table. --Imad www.EnterpriseDB.com On 12/1/06, Ezequias Rodrigues da Rocha wrote: > Hi list, > > I am having problem with grants and users on PostgreSQL. > > I am using pgAdmin to connect like other user to test my permissions. > > As the owner of the database I have criated two roles: > > administrators (cannot connect) > ezequias (can connect) > > I give permissions to a table I have: > GRANT SELECT, UPDATE, INSERT ON TABLE base.table1 TO administrators; > > > My user: > CREATE ROLE ezequias LOGIN > NOSUPERUSER NOINHERIT NOCREATEDB NOCREATEROLE; > GRANT administradores TO ezequias; > > My group > CREATE ROLE administradores > NOSUPERUSER NOINHERIT NOCREATEDB NOCREATEROLE; > > When I try to access the table base.table1 with ezequias login the > pgAdmin reports: > (see attached image) > > Could someone tell me what I did wrong ? > Ezequias > > > > ---------------------------(end of broadcast)--------------------------- > TIP 5: don't forget to increase your free space map settings > > > >