1. Open SQL Server Management Studio
(SSMS)
2. Connect to SQL Server using the
proper credentials
3. Expand Security and Logins
4. Right click Logins and select New
Login
5. On this page you assign a Login
name and select the authentication method and default database/language. (Note
only Domains can use Windows Authentication) If you are using SQL
authentication you will need to enter an initial password and choose the
enforcement options for password policy and expiration as well as whether or
not the user will need to change their password when they log in.
6. Click on Server Roles and you can
assign any sever roles you want this user to have.
7. Click on Securable and then click
the Search button. This will bring up the Add Objects dialog box where you can
choose specific objects, objects of a certain type or the server itself. Select
one and click Ok
8. Select Grant, With Grant or Deny
as necessary for any/all of the objects in the explicit box. (Grant will grant
access to the securable, with grant will allow the user to grant access to the
securable and deny will expressly deny permission to the securable no matter
what roles or permissions the user may have)
9. Click on 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 all this is done click on OK to create the user.
No comments:
Post a Comment