Re: "Permission denied" on view

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.
        regards, tom lane