We're Moving!

The Vertica Forum is moving to a new OpenText Analytics Database (Vertica) Community.

Join us there to post discussion topics, learn about

product releases, share tips, access the blog, and much more.

Create My New Community Account Now


permission denied for view owner — Vertica Forum

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