How to Create a Database User in SQL Server - SQL Server DBA Tutorial

In this video you will learn how to create database user in SQL server using SQL Server Management studio as well as T-SQL Script. It demonstrates two ways to create database user, creating database user using Login Window as well as creating database user using security user tab in the database of SQL Server. It goes through various Server Roles such as Public as well as Database role such as db_datareader roles while creating SQL Server Database user.

Scripts used in this video
USE [master]
GO
 

CREATE LOGIN [TECHBROTHERS\kscott] FROM WINDOWS WITH DEFAULT_DATABASE=[master]
GO
 

USE [SalesOrders]
GO
 

CREATE USER [TECHBROTHERS\kscott] FOR LOGIN [TECHBROTHERS\kscott]
GO
 

USE [SalesOrders]
GO

 ALTER ROLE [db_datareader] ADD MEMBER [TECHBROTHERS\kscott]
GO




SQL Server DBA Tutorial- How to Create Database User in SQL Server

2 comments: