Creating Models › Target Servers for Physical Models › Database Property Editors › SQL Azure Property Editors › SQL Azure Database Support in CA ERwin Data Modeler › User Id Properties › Define SQL Azure Users

Define SQL Azure Users

Use the SQL Azure User Id Editor to define database users and their respective properties in a SQL Azure physical model.

To define SQL Azure users

1. Click Target - SQL Azure, Principals, Users on the Model menu.

   The SQL Azure User Id Editor opens.

2. Select the user in the Navigation Grid that you want to define and work with the following options:

   Note: Click New on the toolbar to create a new user. Use the Enter filter text box to filter a very large list of users to quickly locate the one that you want to define.

   Name

   Displays the user name. You can change the user name in this field.

   Schema

   Specifies the default schema for the user. Select a schema from the drop-down list.

   Login Type

   Specifies the login type of the user. Select the login type from the drop-down list.

   Generate

   Generates SQL during forward engineering. Clear the check box if you do not want to generate SQL.

3. Click the General tab and specify the login to associate with the user. Select a login from the drop-down list or click New to open the SQL Azure Login Editor and create a new login.
4. Click the Roles tab to select or remove role usage.
5. Click the Permission tab to define the permissions for the user.
6. (Optional) Click the Comment tab and enter any comments that you want to associate with the user.
7. (Optional) Click the UDP tab to work with user-defined properties for the user.
8. (Optional) Click the Notes tab to view history information and view or edit user notes.
9. Click Close.

   The user is defined and the SQL Azure User Id Editor closes.

More information:

Define Permissions for an Object in a SQL Azure Property Editor

Add a Comment in a Property Editor

Add a UDP in a Physical Property Editor

Edit User Notes or View Object History