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