March 2018
Intermediate to advanced
816 pages
19h 35m
English
SQL Server supports two authentication modes: Windows mode and mixed mode. In Windows mode, when a user connects through a Windows user account, SQL Server validates the account name and password by using information from the operating system. In mixed mode, in addition to Windows authentication, a user can provide a SQL login and password to connect to SQL Server. SQL Server can use and enforce Windows password policy mechanisms.
SQL Server defines two fundamental terms for security: principals and securables. Principals are entities that can request SQL Server resources. They are arranged in a hierarchy in the principal's scope: you can have Windows, server, and database-level principals. A principal can ...