# -*- mode: snippet -*-
# name: grants
# key: grants_
# group: vertica
# condition: (if (string-equal sql-product 'vertica)t)
# --
SELECT grantee, object_name, privileges_description FROM v_catalog.grants WHERE object_type = '${1:$$(yas-choose-value '("RESOURCEPOOL" "ROLE" "SCHEMA" "TABLE" "VIEW" "STORAGELOCATION"))}' ORDER BY grantee $0LIMIT 50;