From: | "Ezequias Rodrigues da Rocha" <ezequias(dot)rocha(at)gmail(dot)com> |
---|---|
To: | Pgadmin-Support <pgadmin-support(at)postgresql(dot)org>, pgsql-sql(at)postgresql(dot)org |
Subject: | Grants |
Date: | 2006-11-30 19:41:51 |
Message-ID: | 55c095e90611301141n16b8f278n43f65ce5613e663d@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support pgsql-sql |
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 | Content-Type | Size |
---|---|---|
image/jpeg | 9.0 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | imad | 2006-11-30 20:24:49 | Re: [SQL] Grants |
Previous Message | novnov | 2006-11-30 18:10:46 | Re: Can tables have calculated columns? |
From | Date | Subject | |
---|---|---|---|
Next Message | imad | 2006-11-30 20:24:49 | Re: [SQL] Grants |
Previous Message | Ezequias Rodrigues da Rocha | 2006-11-30 18:43:11 | Re: Select (1-3) |