"Nikolay" <[email protected]> writes:
> Description: Permission troubles for views
> SELECT * FROM "vw_data"; - permission denied for relation tbl_data. But
> permissions say that user_b can select from tbl_data and from vw_data.
This is not a bug. The view's reference to tbl_data is controlled by
the permissions of the owner of the view. If it didn't work like that,
a view couldn't be used as a permissions gateway.
regards, tom lane
--
Sent via pgsql-bugs mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
