How to Create Login , Create User and Assign Permission to user in SQL SERVER

How to Create Login , Create User and Assign Permission to user in SQL SERVER
This session will help you understand the following concepts :
1.) How to create Login
2.) How to create User and associate user with created login
3.) How to assign permission to created user to access, update or delete database objects in particular database.
#sql ,
#sqlserver ,
#trainingonline ,
#ssis ,
#ssrs,
#adf ,
#sqla ,#sqlqueries ,#SQL Logins, #login
#tutorial,
#sqltraining
#howto
#training

=====To Get More useful video's, please follow below links ======

1.) To learn Learn SQL Server Concepts, visit below playlist

2.) To learn SQL Server Clauses and Keywords, please visit below playlist

3.) For SSIS Tutorial, follow below playlist

4.) For SSRS tutorial, follow below playlist

5.) Python Tutorials, follow below playlist

6.) Azure Data Factory Playlist

7.) Power BI Concepts, Visit below playlist

8.) MS Excel and Google Sheets, follow below playlist

=======My Favorite Study Materials you can check out =====

=========Share, Support and Subscribe =========
Subscribe to my YouTube channel :

Share and like the Facebook Page :

Thank you for Watching
By SQL
By SQL Training Session

Disclaimer : the above links may be amazon affiliate links, which means if you go through it,
I may get some commission but please bear in mind, it won't charge you a single penny
..so if you like the content, keep watching and support my channel.

[nehachaudhary]

Thank you so much for this video. You explained everything very well. Its really helpful for me.

[rabsonlungu]

Well done! Keep sharing helpful details. Thank you

[vinayaka]

Thanks a lot for the video. I was able to create the user by the steps given by you :-)

[vedaanish]

nice one Thanks. It would be good you can extend the video with how to login with new users

[erik]

Thanks. What if I don't get any Securables at 6:57, after having searched for "all objects belonging to the schema: dbo". My database is new and empty, perhaps that's why?

[Kingston_Kayape]

Thank you so much for the video. It's very helpful.

After all of these, will there be any pop up menu prompting the user to login to access the database?
If so, please could you make a video for all procedures to the end where you can come up with the Pop up menu.

Thank you

[sathishthatikayalavlogs]

The way you have explained is pretty good and would have connect to sql server with test login that would be really helpful for beginners, keep educate us❣️ thanks

[gadaripradeep]

Thank you for u r beeter understood but when am try user and login has created but when am going to db permissons in securable then click on dbo it's not aliveted permissions columns does not open can u say which procedure I did the mistck

[solomonagbeibor]

Hi there!

Can't sql codes be written to Create a user for a database and also to assign permission some permissions to the user created? If it can be done, kindly make them available in the comments section for me. Thanks.

[vasudha]

Also you can add info that the particular user can perform only the specified action (select/ insert/ update) to only those database objects that were assigned to the user

[yvhktgf]

Very clear and good tutorial, Just now I've confuse that why I create a account but still cannot login in SQL Authentication step, Now I know there is two layer of security... that's why

[sakhaaskari]

Thank a lot for helping me with my homework ! you are my hero✨✨

[josephpj]

Hi
can you show us how to disable access to Information schema for a specific user?
Ill tell you the case, since i have user created and assigned for a specific DB access, but using some sql injection someone came inside using web application(th user assigned for a web application) and displays information schema details.

[mario-t]

Thanks much, I did everything but still not allowed use new user to connect to my instance with new login and SQL Server Auth. What coul dbe the trick ?

[edictho]

It's a informative video, appreciate your efforts Ms.Mamta

[ntndoxg]

how to run and this is able to log in any computer?

[VictorBombella]

Ok, but then I get an error while trying to login by writing the "testUser" and the password in the "Connect to Server" dialog... is there any way to "build" the "Login" name to connect to the server?

[ankeetagrawalla]

Object reference not set to an instance of an object(SqlMgmt)

This is the error when i am going in the user properties please help

[behappy]

after create log in an error " user does not have permission to perform this action