Brian Hirt <bhirt@xxxxxx> 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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
