Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id 9E9289FA173 for ; Fri, 1 Dec 2006 10:03:47 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-new, port 10024) with ESMTP id 95171-04 for ; Fri, 1 Dec 2006 10:03:41 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 Received: from ug-out-1314.google.com (ug-out-1314.google.com [66.249.92.170]) by postgresql.org (Postfix) with ESMTP id 0C9F79FA178 for ; Fri, 1 Dec 2006 10:03:40 -0400 (AST) Received: by ug-out-1314.google.com with SMTP id k3so2182561ugf for ; Fri, 01 Dec 2006 06:03:39 -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=AVmEwb+KKJhH9eoue9nMTDGnPyJo+6tEpIiRaO8Upmg4zGEhTRIpjYcLZfNwQvfgsY7gw+sDeOJBKpWvu/2xPwP6SHY8fFath/e0azs7ACpSD9THciYP6l5oRW2b0qKZpCphu6aFtGhVl7NurZdyhpqx26K5v7IgGNk1MnjhMU4= Received: by 10.67.19.20 with SMTP id w20mr7273786ugi.1164981818449; Fri, 01 Dec 2006 06:03:38 -0800 (PST) Received: by 10.67.118.11 with HTTP; Fri, 1 Dec 2006 06:03:38 -0800 (PST) Message-ID: <55c095e90612010603r11d2b1e0ibecc0fdee900f679@mail.gmail.com> Date: Fri, 1 Dec 2006 12:03:38 -0200 From: "Ezequias Rodrigues da Rocha" To: imad Subject: Re: [SQL] Grants Cc: Pgadmin-Support , pgsql-sql@postgresql.org In-Reply-To: <1f30b80c0611301224r135849ffg2426291a42afa29@mail.gmail.com> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: quoted-printable Content-Disposition: inline References: <55c095e90611301141n16b8f278n43f65ce5613e663d@mail.gmail.com> <1f30b80c0611301224r135849ffg2426291a42afa29@mail.gmail.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200612/8 X-Sequence-Number: 6275 ####Schema grants#### CREATE SCHEMA base AUTHORIZATION root; GRANT ALL ON SCHEMA base TO root; GRANT USAGE ON SCHEMA base TO administrators; ####Table grants#### GRANT ALL ON TABLE base."local" TO root; GRANT SELECT, UPDATE, INSERT ON TABLE base."local" TO administrators; Still the same problem. :( 2006/11/30, imad : > 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 > > > > > > > > > --=20 =3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-= =3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D Atenciosamente (Sincerely) Ezequias Rodrigues da Rocha =3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-= =3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D- A pior das democracias ainda =E9 melhor do que a melhor das ditaduras The worst of democracies is still better than the better of dictatorships http://ezequiasrocha.blogspot.com/