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"

Daniel_Leybovic

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

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