You must be connected to the Aster Database server before you can create an Aster database. A default database called beehive is created when Aster Database is initialized. To create your first user-defined database, you can connect to the beehive database. If, at any time, you need to undo your database definition, click Reset to delete your entries and begin again.
- In the Navigator, double-click Databases.
- In the Object List Viewer toolbar, click .
- In the Create Database form, type a Name for the new database.
- [Optional] In Encoding, select the character set encoding to use for the new database.
- Click SQL.
- Review the generated statements that will create the new database.
- [Optional] Modify the CREATE statement by returning to previous steps to change your selections.
- Click Commit to create the database.Privileges can be now be assigned to the new database.
- [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 database, then select the rights. Roles Select a role to which you want to grant rights for this database, then select the rights. Public Gives the public role to this database. - Click SQL to review the generated SQL with added GRANT and REVOKE statements.
- Click Commit.