About Lesson
- Security in SQL Server 2012
- Security Enhancements
- Types of Authentications.
- Windows Authentication
- Creating logins from windows users and groups
- Orphan logins
- Windows Authentication
- SQL Server Authentication
- Creating SQL logins and testing logins
- Setting Authentication Mode
- Security Auditing
- Understanding Server roles
- Working with users
- Resolving Orphan users
- Understanding database roles
- Understanding permissions
- Working with certificates and schemas
- Security catalogue views and stored procedures