| From: | Tulio Oliveira <tulio(at)marilia(dot)com> |
|---|---|
| To: | Jose Manuel Lorenzo Lopez <jose-manuel(dot)lorenzo-lopez(at)conti(dot)de> |
| Cc: | PostgreSQL General List <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Permission denied while insert |
| Date: | 2001-02-26 21:12:23 |
| Message-ID: | 3A9AC6B7.4090000@marilia.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Aristide Aragon | 2001-02-26 21:53:56 | Re: Help with pq++ |
| Previous Message | Tulio Oliveira | 2001-02-26 21:09:58 | Trigger sending an eMail |