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."