467,879 Members | 1,259 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 467,879 developers. It's quick & easy.

Problems with GRANTING SELECT to a table


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
Nov 11 '05 #1
  • viewed: 1380
Share:
1 Reply
"Amin Schoeib" <as******@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

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

Nov 11 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by DC_DBA | last post: by
reply views Thread by Michael Fork | last post: by
3 posts views Thread by daveland | last post: by
2 posts views Thread by LazyAnt | last post: by
5 posts views Thread by news | last post: by
reply views Thread by MrMoon | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.