SQL Server Login and User

Logins are Server Level Objects used to ensure secured connection to SQL Instance.

Types of Logins: 
Windows Logins: Applicable for windows users and AD users.
SQL Logins : Applicable for any user including non windows users.


Types of Users:

Windows users:
SQL Users:

How to Create SQL Logins:

USE [master]

GO

CREATE LOGIN [New-Login] WITH PASSWORD=N'Dell@12345' MUST_CHANGE, DEFAULT_DATABASE=[master], CHECK_EXPIRATION=ON

GO

Windows Login:

Create Login Login_For_Windows from Windows;

Adding Login to Server Role  :

Alter Server Role SYSADMIN ADD Member Login-Name

Go

Alter Server Role BULKADMIN ADD Member Login-Name

CREATING USER FOR LOGIN:

USE DBNAME

GO

CREATE USER [New-Login] FOR LOGIN [New-Login]

GO

USE DBNAME

GO

ALTER ROLE [db_owner] ADD MEMBER [New-Login]

GO

Database Object Level Permission:

Use DBNAME

GO

Grant SELECT on Object to User

Grant SELECT on Object to User WITH GRANT OPTION

Grant INSERT on Object to User

Grant UPDATE on Object to User

Grant DELETE on Object to User

Grant CONTROL on Object to User

Grant ALTER on Object to User

Grant TAKE OWNERSHIP on Object to User

• Tweet
• Share
• Share
• Share
• Share