permission denied for view owner

Izayda

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.

Izayda

One more workaround
ALTER VIEW DMAB.test_view OWNER TO dbadmin;

Izayda

ticket 00070724

Izayda

The bug is confirmed - VER-57812