Re: Permission denied while insert

Поиск
Список
Период
Сортировка
От Tulio Oliveira
Тема Re: Permission denied while insert
Дата
Msg-id 3A9AC6B7.4090000@marilia.com
обсуждение исходный текст
Ответ на Permission denied while insert  (Jose Manuel Lorenzo Lopez <jose-manuel.lorenzo-lopez@conti.de>)
Список pgsql-general
Jose Manuel Lorenzo Lopez wrote:

> Hi folks,
>
> I noticed a strange behavior of my DB. Let me explain:
>
> I created a table bdf_users as admin user 'postgres' and granted insert
> access for this table to public.
>
> Now I want to insert a line as user 'jose' (That's me!) and got the
> following message:
>
> ERROR:  bdf_users: Permission denied.
>
> Am I doing anything dumb? I am using postgresql 7.0.3 on SuSE Linux 7.1
> (although I compiled by myself postgresql)
>
> Best Regards
>
> José Manuel Lorenzo López
>


are you inserting directly over the table, or in a view of this table ?

I had problems inserting data in a View with no records ...




regards

Tulio


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

Предыдущее
От: Emmanuel Charpentier
Дата:
Сообщение: Re: Slowdown problem when writing 1.7million records
Следующее
От: John Madden
Дата:
Сообщение: Re: Can PostgreSQL be a mail backend?