On Tuesday 25 November 2003 09:09 am, Tom Lane wrote: > Michael A Nachbaur <[EMAIL PROTECTED]> 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 <[EMAIL PROTECTED]> * http://nachbaur.com/pgpkey.asc */ "`Credit?' he said. `Aaaargggh...' These two words are usually coupled together in the Old Pink Dog Bar." ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html