NonStop SQL/MP Reference Manual

NonStop SQL/MP Reference Manual—142115
C-158
CREATE VIEW Statement
FOR PROTECTION
specifies a protection view. If you omit this clause, the view is a shorthand view.
SIMILARITY CHECK { ENABLE | DISABLE }
authorizes or prohibits similarity checks on a protection view. (You cannot specify
this clause unless you also specify the FOR PROTECTION clause.) The default is
SIMILARITY CHECK DISABLE.
Views that authorize similarity checks (SIMILARITY CHECK ENABLE) have
version 310 or later. Such views cannot be registered in catalogs with old versions or
accessed by older versions of NonStop SQL/MP.
CATALOG catalog
specifies the catalog to hold the description of the view. catalog is the name of
the subvolume that contains the catalog and that is on the same node as the view. For
a protection view, catalog must be the catalog that holds the description of the
underlying table. (If the table is partitioned, then the protection view is partitioned,
too, and each partition of the protection view is registered in the same catalog as the
corresponding partition of the table.)
The default is the current default catalog.
SECURE "rwep"
defines the security assigned to the view. The default is the default security of the
user whose process creates the view.
Security is interpreted differently for protection and shorthand views. For protection
views, you must ensure that users who have write access also have read access. You
must also ensure that purge authority includes the users with authority to purge the
underlying table. For a shorthand view, only purge authority has meaning, even
though you must specify a complete security string. Anyone with authority to read
the underlying tables and views can also read the shorthand view.
See Security
on page S-11 for more information.
WITH CHECK OPTION
specifies that no row can be placed in the database through the view unless the row
satisfies the view definition. WITH CHECK OPTION applies only to protection
views. If you omit this option, a newly inserted row or an updated row need not
satisfy the view definition, which means that such a row can be inserted in the table
but will not appear in the view.
WITH CHECK OPTION does not affect select-statement; rows must always
satisfy the view definition in this case.
WITH HEADINGS
specifies that the heading for a view column is inherited from the underlying table or
view column from which the new view column is derived. If you specify the