The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.

How can we change the owner of the views and projections like we do for tables?

When I tried to use the alter view to change the owner of view, it throws an error: alter table tab1 owner to abc; ALTER TABLE alter view view1 owner to abc; syntax error at or near "owner" alter projection projection1 owner to abc; syntax error at or near "owner"

Comments

Leave a Comment

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

Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.