Join Gerry O'Brien for an in-depth discussion in this video Manage logins and users, part of Securing SQL Server 2012.
As mentioned in a previous lesson, SQL Server…implements security through the use of securables, which are…the database objects, and security principles, which are…the user's inner applications that will access the database.…Knowing how to create the logins and user accounts is the first step…in creating the authentication and authorization…model for your installation of SQL Server.…In this lesson, we'll take a high level overview of the tools and…components for managing the logins and users in a SQL Server database.…Before you begin creating logins, you must know which…authentication mode SQL Server instance is configured to use.…
In this case, right clicking on the…SQL Server instance name and choosing Properties,…navigating to the Security page, will display…for us the current SQL Server authentication mode.…In this instance, we are using Mixed Mode authentication.…This means we can create Windows accounts, or we can create…local SQL Server accounts for authentication…on this instance of SQL Server.…The default authentication mode for an…
- 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