Manipulating User Logins

This topic tells you how to manipulate user logins with dbForge Fusion for SQL Server Security Manager.

A login is a security principal, or an entity that can be authenticated by a secure system. Users need a login to connect to SQL Server.

Security Manager provides an easy way to add, alter or remove users visually without typing an SQL code. To open Security Manager, on the Fusion menu, point to Microsoft SQL Server, and select Security Manager.

Creating a new user login

  1. Open Security Manager.

  2. Click the Create User button above the User List,

    -or-

    Select the Logins node, right-click it, and then select New Login on the shortcut menu.

  3. Fill the Name field, choose the User type, and fill the fields necessary for the chosen user type.

  4. Click the Save button on the Security Manager toolbar.

Editing a user login

To edit a user login, open Security Manager, expand the Logins node, and then select a required user login in the tree. After editing, click the Save button on the Security Manager toolbar to apply your changes. If you want to discard the changes, click the Undo button.

Deleting a user login

To delete a user login, open Security Manager, expand the Logins node, and then click Delete on the shortcut menu of a required user login; or select a required user login in the tree and press Delete.