Grants

["Ezequias Rodrigues da Rocha" <ezequias(dot)rocha(at)gmail(dot)com>]

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

Attachment: error.JPG
Description: JPEG image