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

From: wieck(at)debis(dot)com (Jan Wieck)
To: Martin Kresse <mkresse(at)slyde(dot)in-berlin(dot)de>
Cc: pgsql-sql(at)postgreSQL(dot)org
Subject: Re: [SQL] "Permission denied" on public view
Date: 2000-02-14 18:50:46
Message-ID: m12KQa6-0003knC@orion.SAPserv.Hamburg.dsh.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?

Jan

--

#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me. #
#========================================= wieck(at)debis(dot)com (Jan Wieck) #

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Mark Volpe 2000-02-14 20:10:59 check_foreign_key with OIDs
Previous Message Martin Kresse 2000-02-14 18:36:07 "Permission denied" on public view