Skip to main content

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

  • December 28, 2015
  • 1 reply
  • 6 views
Igor_Trosko
Forum|alt.badge.img+2

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>

    1 reply

    Forum|alt.badge.img+2
    • Anonymous
    • Participating Frequently
    • January 1, 2016

    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

    Still scrolling?
    Ask a question
    Terms & ConditionsAccessibility statement