After you create an Aster Database role, you can use that role across all databases residing on the same Aster Database server.
- In the Administration perspective, click an Aster connection.
- In the Navigator, double-click on the database in which you want to create the roles. the list of databases in the Object List Viewer
- In the Object List Viewer, display the roles list and click .
- In the Create Role form, click General and type a Name for the new role.
- [Optional] Select the Inherit check box to specify this role inherits the privileges of roles of which it is a member.
-
Click SQL.
- Review the generated statements that will create the new role.
- [Optional] Modify the CREATE statement by returning to previous steps to change your selections.
- Click Commit to create the role.
- [Optional] Click In Roles and specify to which roles the new role.
- [Optional] Click Members of Role and select the Member Type.
- [Optional] Click Object Privileges and define the privileges.
- [Optional] Click SQL to review the generated SQL with added GRANT and REVOKE statements.
-
Click Commit to set the privileges you selected for this role.
You can change any privilege you've set by returning to the Privileges tab and double-clicking a privilege icon.