Previous Topic: Define SQL Server LoginsNext Topic: Define SQL Server Schemas


Define SQL Server Users

Use the SQL Server User Id Editor to define database users and their respective properties in a SQL Server 2008, 2012, 2014 or 2016 physical model.

To define SQL Server users

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

    The SQL Server 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 New icon in property editors to create a new object 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 work with the following options:

    Note: Available options are based on the login type you defined in the Navigation Grid: Login, Certificate, Asymmetric Key, or No Login.

    Login

    Specifies the login to associate with the user, if the login type is set to Login. Select a login from the drop-down list or click New New icon in property editors to create a new object to open the SQL Server Login Editor and create a new login.

    Asymmetric Key

    Specifies the asymmetric key to associate with the user, if the login type is set to Asymmetric Key. Select an asymmetric key from the drop-down list or click New New icon in property editors to create a new object to open the SQL Server Asymmetric Key Editor and create a new asymmetric key.

    Certificate

    Specifies the certificate to associate with the user, if the login type is set to Certificate. Select a certificate from the drop-down list or click New New icon in property editors to create a new object to open the SQL Server Certificate Editor and create a new certificate.

  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 object.
  7. (Optional) Click the UDP tab to work with user-defined properties for the object.
  8. (Optional) Click the Notes tab to view and edit user notes.
  9. Click Close.

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

More information:

Define Permissions for an Object in a SQL Server Property Editor

Work With Roles in a Property Editor

Add a Comment in a Property Editor

Add a UDP in a SQL Server Physical Property Editor