Please help!
Cannot GRANT SELECT access on table to other user.
I do the following:
1) Create database with the name foo,
2) Create table bar,
3) SELECT * FROM bar
4) GRANT SELECT on bar TO dmr
5) Login as user dmr (properly added as Postgres user),
5) SELECT * from bar;
......
(1 row)
The table is readable for dmr,
6) Login as database (foo) and table (bar) creator,
7) SELECT * FROM bar;
ERROR: bar: Permission denied.
Can anybody help?
How can I GRANT SELECT access to my table to another user
no losing access to table for myself?