Received: from localhost (maia-2.hub.org [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id 263A79FA173 for ; Mon, 4 Dec 2006 13:08:34 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-new, port 10024) with ESMTP id 98519-10 for ; Mon, 4 Dec 2006 13:08:26 -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.171]) by postgresql.org (Postfix) with ESMTP id AF6D49F9F7B for ; Mon, 4 Dec 2006 13:08:26 -0400 (AST) Received: by ug-out-1314.google.com with SMTP id k3so2730749ugf for ; Mon, 04 Dec 2006 09:08:25 -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=t04y5t4eHQzWozfLteYAY5RYPUK+DWADp56LVNJh6ILFXNo0CArkuISrfJcThcMlEwsZRu5S55/RH/hk/9lhhvpk+MnjZ9uBUU+B8VvbaUH+0uPH9fTgp+V0JkIbjZ/ilVSR53lU4rAmEo1oOTaBmeqJ76NB1VqLlyqFdzvQjnk= Received: by 10.67.117.18 with SMTP id u18mr12327554ugm.1165252104372; Mon, 04 Dec 2006 09:08:24 -0800 (PST) Received: by 10.67.94.13 with HTTP; Mon, 4 Dec 2006 09:08:24 -0800 (PST) Message-ID: <55c095e90612040908i5b0b7f10gfcff3a0c13774eeb@mail.gmail.com> Date: Mon, 4 Dec 2006 15:08:24 -0200 From: "Ezequias Rodrigues da Rocha" To: "Melvin Davidson" Subject: Re: [SQL] Grants Cc: imad , Pgadmin-Support In-Reply-To: <2CC69F840555CB43B04195F218CCB57F60EFC3@COENGEX01.cctus.com> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: quoted-printable Content-Disposition: inline References: <55c095e90612010603r11d2b1e0ibecc0fdee900f679@mail.gmail.com> <2CC69F840555CB43B04195F218CCB57F60EFC3@COENGEX01.cctus.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200612/23 X-Sequence-Number: 6290 Thank you so much. Now everything is ok. My real best regards Ezequias Rodrigues da Rocha 2006/12/2, Melvin Davidson : > Look at your script. > > Your syntax is backward. > > GRANT administradores TO ezequias; > > > Also, you must create the administradores role _BEPORE_ you grant to it/ > It should be: > CREATE ROLE administradores > NOSUPERUSER NOINHERIT NOCREATEDB NOCREATEROLE; > > GRANT ezequias TO administradores ; > > That should fix the problem. > > > -----Original Message----- > From: pgadmin-support-owner@postgresql.org [mailto:pgadmin-support-owner@= postgresql.org] On Behalf Of Ezequias Rodrigues da Rocha > Sent: Friday, December 01, 2006 7:04 AM > To: imad > Cc: Pgadmin-Support; pgsql-sql@postgresql.org > Subject: Re: [pgadmin-support] [SQL] Grants > > ####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 wrot= e: > > > 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 > > > > > > 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 > > > > > > > > > > > > > > > > > -- > =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/ > > ---------------------------(end of broadcast)--------------------------- > TIP 3: Have you checked our extensive FAQ? > > http://www.postgresql.org/docs/faq > --=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/