Creating Views

You can create two types of views:

• CREATE VIEW creates a view that persists across all sessions until it is explicitly dropped with DROP VIEW
• CREATE LOCAL TEMPORARY VIEW creates a view that is accessible only during the current Vertica session, and only to its creator. The view is automatically dropped when the current session ends.

After you create a view, you cannot change its definition. You can replace it with another view of the same name; or you can delete and redefine it.

Create Permissions

To create a view, you must be a superuser or have the following privileges:

Privilege	Objects
CREATE	Schema where the view is created.
SELECT	Tables and views referenced by the view query.
USAGE	All schemas that contain tables and views referenced by the view query.

For information about enabling users to access views, see Enabling View Access.