Re: schema-qualified permission problem

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: schema-qualified permission problem
Дата
Msg-id 9237.1054165672@sss.pgh.pa.us
обсуждение исходный текст
Ответ на schema-qualified permission problem  (Charlie Toohey <ctoohey@pacbell.net>)
Список pgsql-sql
Charlie Toohey <ctoohey@pacbell.net> writes:
> Why can't my primary user (ttvuser) access tables (owned by owneruser) for
> which they've been granted access?  I can describe the table, but can't
> read it.

> ttvdev=> select count(*) from owneruser.users;
> ERROR:  owneruser: permission denied

You didn't grant USAGE permission on the owneruser schema.
        regards, tom lane


В списке pgsql-sql по дате отправления:

Предыдущее
От: "Matthew Nuzum"
Дата:
Сообщение: recursive srf
Следующее
От: "jack"
Дата:
Сообщение: The problems about temporary tables in V7.3.2