Brian Hirt <bh...@me.com> writes:
> I'm upgrading our database from 8.4 to 9.2 and I've run across a view that is
> no longer working. When selecting from the view, I get a permission denied
> error on one of the referenced tables. However, I can run the view's query
> directly without problems and I have read access to all the tables the view
> accesses.
Permissions checks for tables referenced by a view are done as the view's
owner. I'm suspicious that one of the relations used in your view
vcredit_info is itself a view that references developer_title, and
is owned by some other user with less privilege than you.
regards, tom lane
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
