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. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html