Associating Database Roles with New Database Users

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

Go Up to Establishing Database Security

After you have a database role defined, you can assign that role to any new users created. 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 Window, expand the logical or physical Main Model, right-click the Users node, and then click New Database User.
  2. On the first page of the wizard, click Add in the Roles area and then choose the roles you want to apply.
  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.

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

See Also