Views

Views are created using the CREATE VIEW statement

For example, a common use case is to create a view which queries a table with a pre-defined filter:

In order to be able to query data from a view, a user needs to have privileges on a view. DQL privileges can be granted on a cluster level, on the schema in which the view is contained, or the view itself. Privileges on relations accessed by the view are not necessary.

However, it is required, at all times, that the owner (the user who created the view), has privileges on all relations occurring within the view’s query definition.

See also