From: | "Amin Schoeib" <aschoeib(at)4tek(dot)de> |
---|---|
To: | <pgsql-general(at)postgresql(dot)org> |
Subject: | Problems with GRANTING SELECT to a table |
Date: | 2003-09-02 13:04:59 |
Message-ID: | 70DD6153277512439CA4B66956A3098132D075@pdc.4tek-net.4tek.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi,
I have a problem with permissions for SELECT.
Here is what I did:
test=> GRANT SELECT ON "poi"."fondsstamm" TO "flex";
GRANT
test=> \dp fondsstamm;
Access privileges for database "test"
Schema | Table | Access privileges
--------+------------+-------------------------------
poi | fondsstamm | {=arwdRxt,poi=arwdRxt,flex=r}
(1 row)
Now when I try to select from the table poi.fondsstamm
I become always the error: Permission denied,
> psql test flex
Welcome to psql 7.3.2, the PostgreSQL interactive terminal.
Type: \copyright for distribution terms
\h for help with SQL commands
\? for help on internal slash commands
\g or terminate with semicolon to execute query
\q to quit
test=> select * from poi.fondsstamm;
ERROR: poi: permission denied
What am I doing wrong??
Thanxx
Schoeib
4Tek Gesellschaft für angewandte Informationstechnologien mbH
Schoeib Amin
Tel. +49 (0) 69 697688-132
Fax. +49 (0) 69 697688-111
http://www.4tek.de
From | Date | Subject | |
---|---|---|---|
Next Message | Amin Schoeib | 2003-09-02 13:08:23 | LAST_DAY Function in Postgres |
Previous Message | Shridhar Daithankar | 2003-09-02 12:07:59 | Re: Commercial postgresql |