SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
A-51
Considerations—ALTER VIEW
SIMILARITY CHECK { ENABLE | DISABLE }
authorizes or prohibits similarity checks on a protection view. (You cannot specify
this clause for a shorthand view.)
Authorizing similarity checks (SIMILARITY CHECK ENABLE) on a view whose
version is older than 310 increases the version of the view (and the version of
objects that depend on the view) to 310. Such a view cannot be registered in an
older version catalog or accessed by older versions of NonStop SQL/MP.
Prohibiting similarity checks (SIMILARITY CHECK DISABLE) on a view that has
version 310 decreases the version of the view (and the version of objects that
depend on the view).
Considerations—ALTER VIEW

To rename a view or alter security attributes for a view, you must be a generalized
owner of the view. You must also have authority to read the view.
You must have authority to read and write to the catalogs that describe the view
and any associated objects. If you rename a view, all dependent programs are
invalidated.
If a view to be renamed is a protection view, the underlying table and indexes must
be accessible and you must have read and write authority.
Only one DDL statement can operate on a given SQL object (or partition of an SQL
object) at a time. An error occurs if you attempt to execute an ALTER VIEW
statement while another process is executing a DDL operation on the same object.
The specific error depends on the DDL operation involved and the phase of the
operation at which the conflict occurs. For more information, see DDL (Data
Definition Language) Statements on page D-20.

Changing an attribute of a view can change the version of the view (and the
version of objects that depend on the view).

These dependencies apply when you alter view security attributes:
OWNER and
SECURE
A change in the ownership of a view affects the
interpretation of the security string. The security string is
interpreted at run time against the new owner and, if
applicable, a new group.
If another process is using a view when the owner or
security string is changed, the process might not be able
to access the view after the view is closed.
SECURE A security string must ensure that users who have write
access also have read access.