Re: permission problems

Поиск
Список
Период
Сортировка
От Christopher Kings-Lynne
Тема Re: permission problems
Дата
Msg-id 421D9CCE.6020300@familyhealth.com.au
обсуждение исходный текст
Ответ на permission problems  (Ron Ellingson <rellingson@satshot.com>)
Список pgsql-php
> I am having a problem adding a row to a postgresql table with a sequence
> as a primary key using pg_query.  I receive an error, "permission denied
> for sequence mytable_tid_seq".  I have set the permissions for the user
> from all which did not work to insert, update and select which did not
> work.  Can you  help.  Thanks

GRANT SELECT, UPDATE ON sequence mytable_tid_seq TO ...;

Chris

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

Предыдущее
От: Martín Marqués
Дата:
Сообщение: Re: permission problems
Следующее
От: Zouari Fourat
Дата:
Сообщение: Encoding problems