Permission denied while insert

From: Jose Manuel Lorenzo Lopez <jose-manuel(dot)lorenzo-lopez(at)conti(dot)de>
To: PostgreSQL General List <pgsql-general(at)postgresql(dot)org>
Subject: Permission denied while insert
Date: 2001-02-26 18:20:35
Message-ID: 3A9A9E73.CCCEAC3A@conti.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

--
**********************************************************************
** José Manuel Lorenzo López **
** **
** ICA Informationssysteme Consulting & Anwendungsgesellschaft mbH **
** Dept. SAP Basis R/3 VBue **
** **
** e-mail to: jose-manuel(dot)lorenzo-lopez(at)conti(dot)de **
**********************************************************************

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Aristide Aragon 2001-02-26 18:51:11 Re: Help with pq++
Previous Message Tulio Oliveira 2001-02-26 18:10:58 PG_DUMP permissions