HAS_TABLE_PRIVILEGE
Returns true or false to verify whether a user has the specified privilege on a table.
Behavior Type
Syntax
HAS_TABLE_PRIVILEGE ( [ user, ] '[[database.]schema.]table', 'privilege' )
Parameters
user
|
Name or OID of a database user. If omitted, Vertica checks privileges for the current user. |
[database.]schema
|
Database and schema. The default schema is |
table
|
Name or OID of the table to check. |
privilege
|
A table privilege, one of the following:
|
Privileges
Non-superuser, one of the following:
- Table owner
- USAGE privilege on the table schema and one or more privileges on the table
Examples
=> SELECT HAS_TABLE_PRIVILEGE('store.store_dimension', 'SELECT'); HAS_TABLE_PRIVILEGE --------------------- t (1 row) => SELECT HAS_TABLE_PRIVILEGE('release', 'store.store_dimension', 'INSERT'); HAS_TABLE_PRIVILEGE --------------------- t (1 row) => SELECT HAS_TABLE_PRIVILEGE(45035996273711159, 45035996273711160, 'select'); HAS_TABLE_PRIVILEGE --------------------- t
(1 row)