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

Can't give owner's permission for vertica user (not dbadmin)

I want to give permission drop table, truncate table to regular vertica user (not dbadmin) for one of schems. How I can do it for Vertica 7.1 version? I've given grant all to the schema the user and table which I want to drop when I tried to do it, I've seen message: but ROLLBACK 3989:  Must be owner of relation <table_name>

Comments

  • The ability to drop or alter a table is reserved for a superuser or the table owner. This privilege cannot be granted to other users.

     

    I hope that helps,

     

    Sarah L

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.