GRANT bug

Поиск
Список
Период
Сортировка
Искать

GRANT bug

От:
"Vladimir V. Zolotych" <gsmith@eurocom.od.ua>
Дата:
  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?

Re: GRANT bug

От:
Oleg Broytmann <phd@phd.russ.ru>
Дата:
On Thu, 13 Apr 2000, Vladimir V. Zolotych wrote:
> How can I GRANT SELECT access to my table to another user
> no losing access to table for myself?

   Grant it to yourself, too.

Oleg.
---- 
    Oleg Broytmann    http://members.xoom.com/phd2.1/    phd2@earthling.net
           Programmers don't die, they just GOSUB without RETURN.
FAQ