Skip site navigation (1) Skip section navigation (2)

Re: [SQL] Grants

From: imad <immaad(at)gmail(dot)com>
To: "Ezequias Rodrigues da Rocha" <ezequias(dot)rocha(at)gmail(dot)com>
Cc: Pgadmin-Support <pgadmin-support(at)postgresql(dot)org>, pgsql-sql(at)postgresql(dot)org
Subject: Re: [SQL] Grants
Date: 2006-11-30 20:24:49
Message-ID: 1f30b80c0611301224r135849ffg2426291a42afa29@mail.gmail.com (view raw or flat)
Thread:
Lists: pgadmin-supportpgsql-sql
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 <ezequias(dot)rocha(at)gmail(dot)com> 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
>
>
>
>

In response to

  • Grants at 2006-11-30 19:41:51 from Ezequias Rodrigues da Rocha

Responses

pgadmin-support by date

Next:From: Raymond O'DonnellDate: 2006-11-30 21:02:28
Subject: Speling
Previous:From: Ezequias Rodrigues da RochaDate: 2006-11-30 19:41:51
Subject: Grants

pgsql-sql by date

Next:From: Pascal TufenkjiDate: 2006-12-01 06:31:41
Subject: retrieve row number
Previous:From: Ezequias Rodrigues da RochaDate: 2006-11-30 19:41:51
Subject: Grants

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group