Thread: Problems with GRANTING SELECT to a table

Problems with GRANTING SELECT to a table

From
"Amin Schoeib"
Date:

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

Re: Problems with GRANTING SELECT to a table

From
Tom Lane
Date:
"Amin Schoeib" <aschoeib@4tek.de> writes:
> Here is what I did:
> test=3D> GRANT SELECT ON "poi"."fondsstamm" TO "flex";
> Now when I try to select from the table poi.fondsstamm
> I become always the error: Permission denied,

Did you grant usage on the schema "poi" ?

            regards, tom lane