Ownership error in Vertica

avinash1 · February 2020

Hello,
I have two vertica users say A & B.
A has created a table with his login credentials and gave all the permission to user B on this table.
But when B trying to drop the table with his credentials, he is getting the below error.
ROLLBACK: Must be owner of relation check_tbl

Question:
It is possible for a table that can have multiple owners?
How can user B drop this table?Any alternative.

Regards,
Avinash

Arumugaguru_M · February 2020

Hi,
The owner will be always the person who created the table but he can grant drop privilege to another user
In your case, if the GRANT for the drop is available to USER B from USER A, USER B too can drop the table.
Check this out:
https://www.vertica.com/docs/9.2.x/HTML/index.htm#Authoring/SQLReferenceManual/Statements/GRANT/GRANTTable.htm
This feature is available from version 9.2.1 only not before that.

We're Moving!

Create My New Community Account Now

Ownership error in Vertica

Answers

Leave a Comment