Privileges That Can Be Granted on Objects
The following table provides an overview of privileges that can be granted on (or revoked from) Vertica database objects:
Create | Usage | Execute | Select | Insert | Delete | Update | References | Read | Write | Truncate | |
Database | Y | ||||||||||
Schema | Y | Y | Y | Y | Y | Y | Y | Y | |||
Table | Y | Y | Y | Y | Y | Y | |||||
View | Y | ||||||||||
Sequence | Y | ||||||||||
Procedure | Y | ||||||||||
UDx | Y | ||||||||||
Library | Y | ||||||||||
Resource Pool | Y | ||||||||||
Storage Location | Y | Y | |||||||||
Model | Y |