Join Gerry O'Brien for an in-depth discussion in this video SQL Server principals, part of Securing SQL Server 2012.
In the lesson on SQL Server securables, you learned…about the objects in the database, that can be secured.…In this lesson, we look at security principles, which…represent the entities that security will be applied to.…Security principles request access to SQL Server resources.…Which means they can be users, or they can be applications.…Applying effective security to these principles, permits SQL…Server to serve the data request, while ensuring security…is maintained, without undue impairment on access to the system.…SQL Server breaks down the security…principals, into three high level categories.…
Windows level principals, which consist of domain and local logins.…SQL Server level principals, such as SQL Server logins and server roles.…And then database level principals, such as…database users, database roles, and application roles.…SQL Server can use mixed mode authentication, or Windows authentication.…If we look at the properties of the server, and on the security page,…this is where we can determine which…
- Understanding security best practices
- Managing logins and users
- Understanding how SQL Server checks permissions
- Creating and assigning logins and roles
- Securing SQL on the network