How do I view the owner of a Vertica table?

Question

I have a table in Vertica that I cannot delete because I am not the owner. How do I know who owns a table?

+3

kevingessner 11 oct. 14 at 14:55

1 answer

Kermit · Accepted Answer · 2014-10-11T18:54:52+0000

If you are not the owner of the table or do not have permission to view the table, you most likely cannot find out who is the owner:

SELECT table_schema, table_name, owner_name FROM v_catalog.tables;