Associating Database Users with New Database Roles

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

Go Up to Establishing Database Security

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

  1. In the Data Model Window, expand the logical or physical Main Model, right-click the Roles node, and then click New Database Role.
  2. On the first page of the wizard, in the Roles area click Add and 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.

  • 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.

See Also