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

[@rabsonlungu]

Well done! Keep sharing helpful details. Thank you

[@LearnWithMRajput]

Thank you! Will do!

[@nehachaudhary1541]

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

[@ДмитрийМедведев-б1м]

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

[@LearnWithMRajput]

Glad to know its useful

[@pritamchauhanrajput2055]

Nice Session it's very helpful Many thanks😊

[@vinayaka11]

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

[@LearnWithMRajput]

Glad to know that...Happy learning

[@sakhaaskari3391]

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

[@LearnWithMRajput]

Thank you for such a lovely comments

[@hrushikeshkhonde7079]

Nice Explanation... 👏👏🙂

[@LearnWithMRajput]

Thank you

[@priyankamukherjee2831]

Extremely helpful!!

[@MuhammadUsman-yf3bt]

great video

[@jugadoraaa]

excellent it worked instantly.

[@AltayBrusan]

Thank you! It was very useful

[@LearnWithMRajput]

Thank you..Glad to know it

[@erik9817]

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?

[@sathishthatikayalavlogs176]

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

[@LearnWithMRajput]

Thank you so much Sathish for such kind words... :)

[@sathishthatikayalavlogs176]

@@LearnWithMRajput do we have covered all topics related to sql DBA?

[@ehsanullahkhosrowy8569]

thanks for your information

[@mun_alhe]

Thanks for your information ❤

[@UCASakthibalaj]

Thanks for your information.

[@honkeykong5521]

This was awesome, thank you.

[@LearnWithMRajput]

Great..keep watching

[@lavanyak459]

Very helpful 👍😊

[@LearnWithMRajput]

Glad to know it 😌

[@只是一个路过的]

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

[@DILEEPSAJJAN]

Thanks, that was helpful.

[@LearnWithMRajput]

Glad to know 😌

[@noanswerrs]

lovely jobely, thanks :D

[@achombo]

very helpful

[@vasudha7990]

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

[@LearnWithMRajput]

Noted

[@sultana11000]

Your explanation was good. I would highly recommend showing/verifying whatever you have created (Login, Users, Permissions) to make your lesson easier for the learners. I want to see/learn how your permissions work. Can the user (testUser) able to Update anything? Please next time show us with verifications.

[@LearnWithMRajput]

Thanks for the tips!

[@solomonagbeibor9728]

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.

[@behappy9776]

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

[@rinturoy8014]

I learned it as simple ABCD thank you

[@LearnWithMRajput]

Thank you for your lovely feedback :)

[@sureshpal5613]

great video

[@sureshpal5613]

THEN HOW TO CONNECT TO SQL SERVER WITH THE RECENT LOGIN WHICH WE CREATED

[@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

[@mohamedharis8112]

Good 👍

[@CaribouDataScience]

Thanks

[@baljeetgill5244]

Thank you so much

[@LearnWithMRajput]

Glad that it is useful..Keep watching all vedios

[@vedaanish2015]

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

[@asddfgist]

thank you for your vedio, I have try to do it , I encountered this error "User does not have permission to perform this action. (Framework Microsoft SqlClient Data Provider"

[@josephpj5978]

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.

[@ugaindransubramaniam9237]

Hi, I tries login using the testlogin id but its throwing error 18456. But the password and login is correct. May need some help here.

[@mustafamagdy9324]

Thank You very much

[@LearnWithMRajput]

Glad it helped

[@mario17-t34]

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 ?

[@ankeetagrawalla4416]

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

[@jod6218]

niceee......

[@LearnWithMRajput]

Thanks

[@turkyt]

didi good informaction

[@LearnWithMRajput]

It's my pleasure

[@gadaripradeep492]

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

[@JobigelDeLapid]

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

[@mohamedalpha3430]

Well understood

[@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?

[@kambamramanji4255]

Well explanation can i have num to more course details

[@srimahesh5352]

thank you well understood

[@LearnWithMRajput]

Glad that it is useful

[@vishalchakor7660]

thnx

[@wedaddams5536]

Thank you

[@GhouseMohammed-lq7ds]

Thankyou

[@LearnWithMRajput]

Welcome

[@Ganeshay-09]

how to grant table to new user to another instance

[@Motherslife756]

when i click on new login, it gives me a script instead of the diologBox!!!!

[@LearnWithMRajput]

Probably you are using azure sql database instead of premised sql server

[@chattoronkaadda4342]

Hi mam, sql 2012 me user sa ka default password kya hota h

[@teachkhmerbinary]

likey

[@learnerenglish5405]

How take backup from users

[@Grow-spher]

I want SQL real time videos pls

[@kadapavenkateshprasad9555]

Tqqq madam

[@brunoalmeida6633]

Just miss the login test at the end :)

[@codingisamazing]

you created the login but you didn't show up how to use it, not a finished tutorial

[@wanderer.1993]

10minutos of blablabla... why you don't show you login in after all? i mean, just failed the login for user...isn't dificult to say "hey, check if you have sqlserver authetnication enable!"