Re: "Permission denied" on view

On Tuesday 25 November 2003 09:09 am, Tom Lane wrote:
> 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.

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

/me goes sheepishly back to work

--
/* Michael A. Nachbaur <mike(at)nachbaur(dot)com>
* http://nachbaur.com/pgpkey.asc
*/

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