From the course: Microsoft SQL Server 2016: Installation and Administration
Unlock the full course today
Join today to access over 22,500 courses taught by industry experts or purchase this course individually.
Implement server permissions - SQL Server Tutorial
From the course: Microsoft SQL Server 2016: Installation and Administration
Implement server permissions
- [Instructor] In thinking about SQL server security and the multiple tiers that are available, we know that we have security at the server level through logins and server roles and we also have security at the database level through users and roles. Once we've created the logins at the server level and created users at the database level, we can now start to consider applying permissions that effectively control what these users can do and can not do on our system. Let's focus on the permissions for logins at the server level. Now before we step in to applying all of our permissions that we want to for our test user, it's important to understand that the complexity of dealing with permissions on SQL server are quite large and to give you an idea, if we step out the msdn page for the permissions for the database engine, you can see this wonderful chart that is known as the SQL server database engine permissions chart. It's very complex. It's goes in a bunch of different directions and…