Creating a View

Create a new regular view by defining a SQL query using the Create View wizard.

Prerequisites

Database Version	View Privileges
SAP Sybase IQ 15.3 and 15.4	You must have one of: DBA authority RESOURCE authority with SELECT permission on the tables in the view definition to create a view owned by you.
SAP Sybase IQ 16.0	View to be owned by self – you must have the CREATE VIEW system privilege. You must also have one of: SELECT ANY TABLE system privilege SELECT object permission on the underlying tables of the view View to be owned by any user – you must have one of: CREATE ANY VIEW system privilege CREATE ANY OBJECT system privilege You must also have one of: SELECT object permission on the underlying tables of the view SELECT ANY TABLE system privilege

Database Version

View Privileges

SAP Sybase IQ 15.3 and 15.4

You must have one of:

DBA authority
RESOURCE authority with SELECT permission on the tables in the view definition to create a view owned by you.

SAP Sybase IQ 16.0

View to be owned by self – you must have the CREATE VIEW system privilege. You must also have one of:

View to be owned by any user – you must have one of:

You must also have one of:

Task

In the Perspective Resources view, select the resource, and select Resource > Administration Console.
In the left pane, expand IQ Servers > Schema Objects > Views, and then select Views.
Click the arrow next to Views and select New.
The Create View Wizard appears.

On the Welcome page, specify

Option	Description
Select a resource for which the view will be created	From the list, select the resource for which the view will be created.
Which user or group do you want to own the view?	From the list, select the user or role/group to own the view.
What do you want to name the view?	Enter a unique name for the new view; maximum of 128 characters.
Comment	Specify a comment for the view.