Re: "Permission denied" on view

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Michael A Nachbaur <mike(at)nachbaur(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: "Permission denied" on view
Date: 2003-11-25 17:09:39
Message-ID: 28490.1069780179@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Michael A Nachbaur <mike(at)nachbaur(dot)com> writes:
> scamp=> select * from Dialup.UserGroup;
> ERROR: dialup: permission denied

You haven't granted USAGE permission on the "dialup" schema to this
user. You need that in addition to select permission on the view itself.

regards, tom lane

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Michael A Nachbaur 2003-11-25 17:27:05 Re: "Permission denied" on view
Previous Message Michael A Nachbaur 2003-11-25 16:55:13 "Permission denied" on view