Assign roles in Security Manager

Roles let you grant a set of privileges to a user at once, rather than granting each privilege individually. You can also assign multiple roles to a single user. This approach simplifies your work as a database administrator.

Note

A role can include other roles.

To assign a role to a user:

1. On the Database menu, select Security Manager.

2. In the tree, select the user account you want to edit.

3. On the Role Membership tab, select one or more roles.

The Role Membership tab with a selected role for a user in the Security Manager window

4. Click Save on the Security Manager toolbar.