Changing Database Roles Associated with Existing Database Users

Go Up to Establishing Database Security

Once you have a database role defined, you can assign that role to any users created. Once defined, the permissions associated with a role can be edited on the Permissions tab of the Entity/Table Editor.

1. In the Data Model Window, expand the logical or physical Main Model, expand the Users node, right-click the user you want to edit, and then click Edit Database User.
2. To add a new role to the user, in the Roles area of the General tab, click Add and select the roles you want to apply.

   To drop a role from the user, in the Roles area of the General tab, click Drop and select the roles you want to remove.

3. Click Finish.

Now, when you edit the database user, if you have selected Show inherited permissions on the Object Privileges tab of the User Editor, you will see blue check marks denoting the granted permissions afforded to the user by the applied roles. Permissions revoked by rules do not display with crosses.

Note: Generally, permissions granted or revoked through the application of a role are overridden by permissions afforded the user in the User Editor, or on the Permissions tab of the Entity/Table Editor. Check your DBMS documentation for verification.

See Also

• Creating and Editing Database Users
• Creating and Editing Database Roles
• Changing Database Users Associated with Existing Database Roles