- In the Navigator, double-click Databases.
-
In the Object List Viewer:
- Locate the database containing the schema where you want to create a view.
- Right-click the schema and click Show Views.
- Click .
- In the Create View form, type a Name for the new view.
- Click the View Query tab and specify one or more source tables in the SELECT * FROM clause.
-
Click the SQL tab.
- Review the generated statements that will create the new view.
- [Optional] Modify the CREATE statement by returning to previous steps to change your selections.
- Click Commit to create the view. Privileges can now be assigned to the view.
-
[Optional] Click the Privileges tab and select a Grantee Type to define the privileges:
Grantee Type Description Users Select a user to whom you want to grant rights for this view, then select the rights. Roles Select a role to which you want to grant rights for this view, then select the rights. Public Gives the public role to this view. - Click the SQL tab to review the generated SQL with added GRANT and REVOKE statements.
- Click Commit.