Re: Permission denied for sequece...

Поиск
Список
Период
Сортировка
От Jon Horsman
Тема Re: Permission denied for sequece...
Дата
Msg-id 4f4c2a010608211527t702939e1i174729175d9bed73@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Permission denied for sequece...  (Scott Marlowe <smarlowe@g2switchworks.com>)
Ответы Re: Permission denied for sequece...
Список pgsql-jdbc
>  Column |  Type   |                      Modifiers
> --------+---------+------------------------------------------------------
>  id     | integer | not null default nextval('public.real_id_seq'::text)
>
> Note that my table, real, has a sequence named read_id_seq.  You need to
> grant all on that as well...

That did it.  Thanks a lot.  I _never_ would have guessed that and
don't recall seeing it in the docs, perhaps i missed it.

While on the topic.  Is there one blanket command that can be run to
grant the user permissions to do everything to the db, without making
that user the owner or a superuser?

Originally i would have thought 'GRANT ALL ON dbname TO user' would
have done this for me, but its obvious it doesn't work that way.

Jon.

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

Предыдущее
От: Scott Marlowe
Дата:
Сообщение: Re: Permission denied for sequece...
Следующее
От: Scott Marlowe
Дата:
Сообщение: Re: Permission denied for sequece...