Skip to main content

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

Nithya_GuruPrak
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"

    3 replies

    Daniel_Leybovic
    Forum|alt.badge.img+1
    Hi! You can't. VIEWs and PROJECTIONs supports in "RENAME TO" only. >> alter view view1 owner to abc Please read documentation. Where did you find such option?
    Nithya_GuruPrak
    I did not find this option anywhere. I assumed it will work for view...my bad. Is there a workaround to do this?
    Bhawana
    Forum|alt.badge.img
    • Bhawana
    • Participating Frequently
    • August 29, 2013
    Hi Nithya, You can not change the view. A feature request to change owner of a view has been entered. As Daniel suggested please review this documentation. https://my.vertica.com/docs/6.1.x/HTML/index.htm#18191.htm Thanks Bhawana
    Still scrolling?
    Ask a question
    Terms & ConditionsAccessibility statement