How do I view the owner of a Vertica table?

Question

I have a table in Vertica that I can't drop, because I'm not the owner. How do I see who the owner of the table is?

Answer 1

If you're not the owner of the table, or do not have have privileges to see the table, then you most likely won't be able to see who the owner is:

SELECT table_schema, table_name, owner_name FROM v_catalog.tables;

Documentation