The Vertica Database Forums

This set of examples shows the privileges a user needs for various operations related to views, including creating and querying. A view is a virtual table based on the result set of a SQL statement, also called a SQL query. To select from a view, you need a combination of privileges on the underlying tables, and their schemas, as well as the view and its schema. This document describes the minimum set of privileges you need to perform certain operations on views.