- In the Administration perspective, click an Aster connection.
- In the Navigator, double-click on the Databases category. The database list opens in the Object List Viewer.
- Locate the database and schema where you want to create a view.
- In the Object List Viewer, click .
- In the Create View form, click General and type a Name for the new view.
- Click the View Query tab.
- Specify one or more source tables in the SELECT * FROM clause.
-
Click SQL.
- 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.
-
[Optional] Click Privileges and 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 SQL to review the generated SQL with added GRANT and REVOKE statements.
-
Click Commit to set the privileges you selected for this database.
You can change any privilege you've set by returning to the Privileges tab and double-clicking a privilege icon.