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

Igor_TroskoIgor_Trosko ✭
in General Discussion

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

  • [Deleted User][Deleted User] Administrator

    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
Format
SpoilerCodeQuote
Heading 2Heading 1
Emoji
:):D:(;):/:o:s:p:'(:|B):#:*<3o:)>:)
Url
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file
Home • General DiscussionComment As ...