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

Igor_Trosko

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>

[Deleted User]

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