permission denied for view owner
We've just updated to 8.1.1-4 and now we observe strange error. All view owners can't select from their views.
Code to reproduce:
SELECT * FROM DMAB.advert_chargeback; -- SUCCESS CREATE or replace view dmab.test_view INCLUDE SCHEMA PRIVILEGES AS SELECT * FROM DMAB.advert_chargeback; -- SUCCESS SELECT * FROM dmab.test_view; -- Permission denied for relation test_view GRANT ALL PRIVILEGES ON dmab.test_view TO lkp; -- Permission denied for relation test_view DROP VIEW dmab.test_view; -- SUCCESS
Workaround is to create view from different user or dbadmin. But this is inacceptable for many use cases.