Create and configure a user in MSSQL
Use the following steps to create and configure a user in MSSQL®:
-
Open the Microsoft ® SQL Server® Management Studio (SSMS).
-
Connect to SQL Server by using your login information.
-
In the left-hand panel, expand Security > Logins.
-
Right-click Logins and select New Login from the drop-down menu.
-
Assign a login name and select the authentication method and default database or language.
If you are using SQL authentication, you must enter an initial password and choose the
enforcement options for password policy and expiration as well as whether or not the user
needs to change their password when they log in. -
In the left-hand panel, click Server Roles to assign any server roles you want
this user to have, including bulkadmin, dbcreator, public, and so on. -
In the left-hand panel, click Securables and then click Search.
The Add Objects dialog box displays, where you can choose specific objects, objects of a
certain type, or the server itself. Select one and click OK. -
On the Securables page, select Grant, With Grant, or Deny as necessary for any of the
objects in the explicit box.Grant gives access to the securable, With Grant allows the user to grant access to the
securable, and Deny expressly denies permission to the securable no matter what roles or
permissions the user might have. -
In the left-hand panel, click Status to grant or deny permission to the database engine,
enable or disable the login, and to unlock the account should it get
locked out.
When you have finished modifying the settings, click OK to create the user and exit the new login creation window.
Updated 10 months ago