You can control whether a regular view is available for use by the database server by enabling or disabling it.
You must be the owner, or have one of the following privileges:
To enable a regular view, you must also have the following privileges SELECT privilege on the underlying table(s), or the SELECT ANY TABLE system privilege.
Before you enable a regular view, you must re-enable any disabled views that it references.
In Sybase Central, use the SQL Anywhere 16 plug-in to connect to the database.
In the left pane, double-click Views.
To disable a regular view, right-click the view and click Disable.
To enable a regular view, right-click the view and click Recompile And Enable.
Discuss this page in DocCommentXchange.
|Copyright © 2014, SAP AG or an SAP affiliate company. - SAP Sybase SQL Anywhere 16.0|