SQL Server 2016 Part 4 - Databases, Logins, Users, Roles and Schemas

By Andrew Gould

This stuff deserves a lot of views! Thanks Andrew!

[ThomasLeopold]

Great video. Explains the basic concepts well, so you can do your own research to dive into it deeper. For those who think he speaks too fast: Why not use Playback Speed = 0.75? 😉

[reapercinq]

What a wonderful tutorial! We use SqlServer quite heavily where I recently started working, and I felt completely lost and dependent on the DB Administrator for anything to do with users, roles, logins, schemas, ; hell I didn't even understand what a database principal meant! Up until now, because after watching this tutorial, I went back to work and did a thorough investigation in our database server of all the server-level and database-level principals and the permissions granted, and I was ecstatic that I finally understood everything! Thank you so much Andrew!

[khaleelrahman]

I like this Video, within a short period of time you can learn a lot of things. it is very good for those who know a little bit about SQL. You are doing a great job for a new student in SQL ( DBA ) course.

[TILARFHT]

Awesome! Can't say how thankful I am.

[MdScientist]

Very informative and easy to follow. Nice and warm voice and good editing.
I hope you will be active because your videos are very good and are helping a lot of people.

[oysteinoren]

Hi Andrew, just wanted to say I'm a great fan of your work. I'm educated as a teacher, and you are definitely the most pedagogical instructor on YouTube! Looking forward to the SQL videos!

[jonkumbi]

Very informative, I'm learning a great deal thanks. As, a College Graduate I am always willing to learn more.

[bencole]

Your knowledge of these subjects astounds me! Thank you for sharing...

[souravroy]

Amazing discussion with necessary details and simple explanation. Thanks Andrew!

[jefrilim]

You're the best. Thanks a lot man :D

[nehabhatt]

Great video really liked it!! Thank You.

[TheRedsky]

Great Video! Really helps me to understand how SQL Server works!

[majetyanu]

I have question that i tried to assign login i. e PRC grouo login to database and im trying to check the database.. Its checks for that time and if i re.. Check it.. It will not be checked... Can u explain me please

[jessegador]

Thank you for sharing your knowledge. This is very helpful.

[BijouBakson]

Amazing stuff! I feel like a SysAdmin already. :) Thank you Andrew

[ghufranataie]

Dear Andrew it great tutorial, allow me to thank you for your this great job, but also allow me to say that you have a British accent and speaks a little fast which is hard to understand for not native English speakers, once again thank you and you do wonderful job

[sglgaming]

Hello Andrew, i followed exactly what you've done to create a new user, However i fail to login with it with the same error as in 19:50
I double checked the server authentication more and it is SQL Server and windows, the database is at the server and i'm trying to login from my computer.

When i give it "sysadmin" role it connects successfully, but that also gives the user all permissions no matter what i select as deny afterwards ! can you please help me here ? it's very important

[datachamp]

Thanks, very good and concise explanation

[cormackeenan]

Andrew is excellent at explaining things so I know it's my problem but I'm completely bamboozled by this video, and also a little bit scared of locking myself out of the server, I think I can under users and roles but schema has me completely flummoxed.