View Privileges

A view is a stored query that dynamically accesses and computes data from the database at execution time. Use \dv in vsql to display available views. By default, only the following users have privileges to access a view's base object:

To execute a query that contains a view, you must have:

You can assign view privileges to other users and roles using GRANT (View). For example:

=> GRANT all privileges on view1 to role1 with grant option;
=> CREATE ROLE role1;
=> CREATE ROLE role2;

=> GRANT role1 to role2;

See Also

GRANT (View)

REVOKE (View)