Privileges That Can Be Granted on Objects
The following table provides an overview of privileges that can be granted on (or revoked from) database objects in Vertica:
| 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 |