Define at least one schema in an Aster database before you create tables, views, or other objects or move data.
- In the Navigator, double-click Databases.
-
In the Object List Viewer:
- Double-click the database in which you want to create a new schema.
- Click .
- In the Create Schema form, type a Name for the new schema.
-
Click SQL.
- Review the generated SQL statements that will create the new schema.
- [Optional] Modify the CREATE statement by returning to previous steps to change your selections.
- Click Commit. You can now assign privileges to the schema.
-
[Optional] Click Privileges 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 schema, then select the rights. Roles Select a role to which you want to grant rights for this schema, then select the rights. Public Gives the public role to this schema. - Click SQL to review the generated SQL with added GRANT and REVOKE statements.
- Click Commit.