Postgres Pro
Downloads
Home   >   mailing lists

Re: "Permission denied" on view - Mailing list pgsql-sql

From Tom Lane
Subject Re: "Permission denied" on view
Date
Msg-id 28490.1069780179@sss.pgh.pa.us
Whole thread Raw
In response to "Permission denied" on view  (Michael A Nachbaur <mike@nachbaur.com>)
Responses Re: "Permission denied" on view  (Michael A Nachbaur <mike@nachbaur.com>)
List pgsql-sql
Tree view 
Michael A Nachbaur <mike@nachbaur.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

pgsql-sql by date:

Previous
From: Michael A Nachbaur
Date:
Subject: "Permission denied" on view
Next
From: Michael A Nachbaur
Date:
Subject: Re: "Permission denied" on view