Changing Database Users Associated with Existing Database Roles

From ER/Studio Data Architect
Jump to: navigation, search

Go Up to Establishing Database Security

Once you have a database user defined, you can assign a role to that user. Once defined, the permissions granted to users directly or by applying roles can be edited on the Permissions tab of the Entity Editor.

  1. In the Data Model Explorer, expand the logical or physical Main Model, expand the Roles node, right-click the role you want to change, and then click Edit Database Roles.
  2. Click the General tab.
  3. To associate the role with a user, in the Users area of the General tab, click Add and choose the users you want to associate with the role.
    To disassociate a role from a user, in the Users area of the General tab, in the Users area click Drop and choose the users you want to disassociate from the role.
  4. 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.

  • Permissions granted by applying roles are overridden by permissions granted to the user in the User Editor, or on the Permissions tab of the Entity/Table Editor.

See Also