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.

Comments

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file