Skip to main content

permission denied for view owner

  • Sep 10, 2017 2:08 PM UTC
  • 3 replies
  • 27 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
  • Sep 10, 2017 2:31 PM UTC

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


Izayda
Forum|alt.badge.img
  • Author
  • Participating Frequently
  • Sep 27, 2017 2:28 PM UTC

ticket 00070724


Izayda
Forum|alt.badge.img
  • Author
  • Participating Frequently
  • Sep 29, 2017 9:06 AM UTC

The bug is confirmed - VER-57812