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

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.

Blog link for this video with scripts

Visit our website to check out SQL Server DBA Tutorial Step by Step

[lorenzocernecca]

This video was perfect in explaining how to do the same task via GUI and SQL query. Thank you so much

[LEARNER]

Great effort, cannot thank you enough. keep up the great work.

[vincenzomarzulli]

Hi,

i appreciated your clear explanation, thank you! 

I am in the need of creating multiple logins who will all have access to the same databases. How can i create multiple users in just one script?

Thank you for your preciuos time!

[sexyeyes]

The video is technically not for beginners for home end-users ..since it requires Windows Server (Active Directory) to authenticate/authorize SQL Login ... unless users know how to setup Virtual environments.