Re: [SQL] "Permission denied" on public view

From: "Martin Kresse" <mkresse(at)slyde(dot)in-berlin(dot)de>
To: Jan Wieck <wieck(at)debis(dot)com>
Cc: pgsql-sql(at)postgreSQL(dot)org
Subject: Re: [SQL] "Permission denied" on public view
Date: 2000-02-15 15:01:34
Message-ID: 200002151457.e1FEvfD05304@einhorn.in-berlin.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

> > However, when I try the exact same statement with a different user,
> > I get the error message:
> > ERROR: data: Permission denied.
> >
> > When I remove the ins_data rule, the INSERT works for the other
> > users as well. Does the rule need access to the data table? Is this
> > a bug or am I doing something wrong?
>
> Anything seems right for me. And I cannot reproduce this
> error in the current developers tree (it works as it should).
>
> Which version of PG are you using?

Today, I installed PG 6.5.3, which behaves exactly the same.
Prior I have been using PG 6.5.1.

Martin

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Carl Flansbaum 2000-02-15 17:08:46 Techniques for quickly finding words in a phrase...
Previous Message Peter Eisentraut 2000-02-15 12:17:37 Re: [SQL] is there a mysql to postgresql sql converter?