How to manipulate user logins

This topic tells you how to manipulate user logins with 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 Database menu, select Security Manager.

Creating a new user login

  1. Open Security Manager.
  2. Click the Create User button above the User List. Alternatively, select the Logins node, right-click it, and then select New Login from 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 from the shortcut menu of a required user login; or select a required user login in the tree and click Delete.

Want to Find out More?

Overview

Overview

Take a quick tour to learn all about the key benefits delivered by dbForge Studio for SQL Server.
All Features

All features

Get acquainted with the rich features and capabilities of the Studio in less than 5 minutes.
Request a demo

Request a demo

If you consider employing the Studio for your business, request a demo to see it in action.
Ready to start using dbForge Studio for SQL Server?