Viewing or Modifying View Properties

View or change view properties including the comment, SQL view definition (including the column definition), and permissions. Modifying a view changes the definition of the view but does not change data inside the view.

Prerequisites

Database Version	View Privileges
SAP Sybase IQ 15.3 and 15.4	View any view property page – None required. Modify view permissions – Requires one of: DBA authority. PERMS ADMIN authority. Administrative rights over the permission. You own the database object. Modify any other view property except those relating to triggers – Requires one of: DBA authority. You own the view. For privileges relating to triggers, see: View Trigger Privilege Summary
SAP Sybase IQ 16.0	View any view property page – None required. Modify view permissions – Requires one of: MANAGE ANY OBJECT PRIVILEGE system privilege. You have administrative rights (with grant option) to the permission. You own the database object. Modify a view comment – Requires any one of: CREATE ANY VIEW system privilege. CREATE ANY OBJECT system privilege. ALTER ANY VIEW system privilege. ALTER ANY OBJECT system privilege. COMMENT ANY OBJECT system privilege. You own the view. Modify any other view property, except those relating to triggers – Requires one of: ALTER ANY VIEW system privilege. ALTER ANY OBJECT system privilege. You own the view. For privileges relating to view triggers, see: View Trigger Privilege Summary

Database Version

View Privileges

SAP Sybase IQ 15.3 and 15.4

View any view property page – None required.

Modify view permissions – Requires one of:

DBA authority.
PERMS ADMIN authority.
Administrative rights over the permission.
You own the database object.

Modify any other view property except those relating to triggers – Requires one of:

DBA authority.
You own the view.

For privileges relating to triggers, see:

View Trigger Privilege Summary

SAP Sybase IQ 16.0

View any view property page – None required.

Modify view permissions – Requires one of:

MANAGE ANY OBJECT PRIVILEGE system privilege.
You have administrative rights (with grant option) to the permission.
You own the database object.

Modify a view comment – Requires any one of:

CREATE ANY VIEW system privilege.
CREATE ANY OBJECT system privilege.
ALTER ANY VIEW system privilege.
ALTER ANY OBJECT system privilege.
COMMENT ANY OBJECT system privilege.
You own the view.

Modify any other view property, except those relating to triggers – Requires one of:

ALTER ANY VIEW system privilege.
ALTER ANY OBJECT system privilege.
You own the view.

For privileges relating to view triggers, see:

View Trigger Privilege Summary

(Modifying properties only) In a multiplex configuration, the coordinator node is running.

Task

In the Perspective Resources view, select the resource and select Resource > Administration Console.
In the left pane, select IQ Servers > Schema Objects > Views > Views.
Select a view from the right pane and either:
- Click the arrow to the right of the name and select Properties, or
- From the Administration Console menu bar, select Resource > Properties.
The View Properties view appears.

View or modify the properties.

When modifying properties, clicking Apply before changing screens is not necessary, but will save any changes.
If you do not have privileges to modify properties, Sybase Control Center displays the properties view in read-only mode.

Area	Description
General	Name – (Read-only) The name of the view. Owner – (Read-only) The owner of the view. Database – (Read-only) The name of the database the view was created for. Status – Current status of the view. Valid statuses are: Valid Disabled Recompile and Enable Now – Allows you to enabled a disabled view. Disable Now – Allows you to disable an enabled view. Comment – Enter a comment on the view.
SQL	View the SELECT statement for the view.
Columns (Read-only)	Name – Column name. ID – Column ID. Data Type – Column Data type. Allows null – Indicates if the column accepts null values. Either Yes or No.
Triggers	(System store tables only.) See View Triggers for details and required privileges and permissions.
Data (Read-only)	Note: For 15.3 and 15.4, requires SELECT permission on the underlying table to view data. For 16.0, requires the SELECT ANY TABLE system privilege to view data. Displays the first 500 rows of data.
Permissions	See View Permissions for details and required privileges and permissions.
Referenced Objects (Read-only)	Name – Table name. Owner – Table owner. Object Type – Referenced object type (Table, for example). Referenced Column – Column ID. Dependency Type – Indicates Direct or Indirect dependency.
Dependent Views (Read-only)	Name – View name. Owner – View owner. View Type – View type. Dependency Type – Indicates Direct or Indirect dependency.

Click OK.