I'm trying to use the System Tables to fetch some metadata about the whole Vertica cluster at a table level (including permissions).
Where can I find the information about permissions required to SELECT on a table?
I've poked around in the GRANTS
and ROLES
system tables, but I can't find any role->table mapping.
I considered using HAS_TABLE_PRIVILEGE()
but that does it on user level. I'd rather do it at the role level.
GRANTS
table). I wasn't able to view them previously because I didn't have the required permissions. I can't post an answer though, because I can't answer my own question for 8 hours.GRANTS
table...GRANTS
table. I hadn't created any tables at that point.