Object-Specific Privileges

The following table provides an overview of privileges that can be granted on Vertica database objects:

  ! Schema privileges that can be inherited by tables and views of that schema. For detailed information, see GRANT (Schema).
  ALTER DROP CREATE DELETE EXECUTE INSERT READ REFERENCES SELECT TRUNCATE UPDATE USAGE WRITE
Database     •                    
Schema ! ! • !   !   ! ! ! ! •  
Table • •   •   •   • • • •    
View • •             •        
Sequence • •             •        
Procedure         •                
User‑defined function • •     •                
Model • •                   •  
Library                       •  
Resource Pool                       •  
Storage Location             •           •

See Also