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 <[EMAIL PROTECTED]> 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
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
