Re: Permission; select currval('seq')

Поиск
Список
Период
Сортировка
От Ivan K
Тема Re: Permission; select currval('seq')
Дата
Msg-id 482009.43147.qm@web65505.mail.ac4.yahoo.com
обсуждение исходный текст
Ответ на Re: Permission; select currval('seq')  (Adrian Klaver <aklaver@comcast.net>)
Список pgsql-general
Yes, that was the ticket; the commands I needed to
execute are as follows:

GRANT UPDATE ON  bla_bla_id_seq TO GROUP test_group_01;
GRANT SELECT ON  bla_bla_id_seq TO GROUP test_group_01;
GRANT INSERT ON  bla_bla_id_seq TO GROUP test_group_01;

Thanks!

--- On Sat, 1/2/10, Adrian Klaver <aklaver@comcast.net> wrote:
>
>
>
> From here;
> http://www.postgresql.org/docs/8.1/interactive/sql-grant.html
>
> GRANT USAGE is for procedural languages and SCHEMA.
>
> You will need to use the GRANT SELECT|INSERT ON  TABLE
> bla_bla_id_seq form.
> Sequences being a type of table and not having their own
> GRANT form until later
> versions.






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

Предыдущее
От: Jamie Kahgee
Дата:
Сообщение: split to table by space
Следующее
От: Brian Modra
Дата:
Сообщение: Re: split to table by space