Skip to main content

permission denied for view owner

  • September 10, 2017
  • 3 replies
  • 17 views

Izayda
Forum|alt.badge.img
  • Participating Frequently

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.

3 replies

Izayda
Forum|alt.badge.img
  • Author
  • Participating Frequently
  • September 10, 2017

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


Izayda
Forum|alt.badge.img
  • Author
  • Participating Frequently
  • September 27, 2017

ticket 00070724


Izayda
Forum|alt.badge.img
  • Author
  • Participating Frequently
  • September 29, 2017

The bug is confirmed - VER-57812