Received: from localhost (maia-2.hub.org [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id 02AC89F9F47 for ; Sat, 2 Dec 2006 16:30:55 -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 47494-04 for ; Sat, 2 Dec 2006 16:30:37 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from coengex02.cctus.com (mail.arxceo.com [63.123.142.18]) by postgresql.org (Postfix) with ESMTP id 72F519F9392 for ; Sat, 2 Dec 2006 16:30:45 -0400 (AST) Received: from COENGEX01.cctus.com ([192.168.129.21]) by coengex02.cctus.com with Microsoft SMTPSVC(6.0.3790.1830); Sat, 2 Dec 2006 13:31:09 -0700 X-MimeOLE: Produced By Microsoft Exchange V6.5 Content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Subject: Re: [SQL] Grants Date: Sat, 2 Dec 2006 13:31:07 -0700 Message-ID: <2CC69F840555CB43B04195F218CCB57F60EFC3@COENGEX01.cctus.com> In-Reply-To: <55c095e90612010603r11d2b1e0ibecc0fdee900f679@mail.gmail.com> X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: [pgadmin-support] [SQL] Grants Thread-Index: AccVUZpkr3agqhxUSk60dVDgZdLW5AA/X7dQ From: "Melvin Davidson" To: "Ezequias Rodrigues da Rocha" , "imad" Cc: "Pgadmin-Support" X-OriginalArrivalTime: 02 Dec 2006 20:31:09.0818 (UTC) FILETIME=[CD2335A0:01C71650] X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200612/13 X-Sequence-Number: 6280 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:=20 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 = 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=20 > > administradores TO ezequias; > > > > My group > > > > When I try to access the table base.table1 with ezequias login the=20 > > pgAdmin reports: > > (see attached image) > > > > Could someone tell me what I did wrong ? > > Ezequias > > > > > > > > ---------------------------(end of=20 > > 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