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

From Michael A Nachbaur
Subject Re: "Permission denied" on view
Date
Msg-id 200311250927.05270.mike@nachbaur.com
Whole thread Raw
In response to Re: "Permission denied" on view  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-sql
On Tuesday 25 November 2003 09:09 am, Tom Lane wrote:
> 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.

Thank you; apparently I didn't RTFM closely enough.

/me goes sheepishly back to work

-- 
/* Michael A. Nachbaur <mike@nachbaur.com>* http://nachbaur.com/pgpkey.asc*/

"`Credit?' he said. `Aaaargggh...'
These two words are usually coupled together in the Old 
Pink Dog Bar."




pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: "Permission denied" on view
Next
From: "Kumar"
Date:
Subject: Re: ::text problem