COMPUTER & TECHNOLOGY PROGRAMS
SQL Server 2008 Security
This course focuses on the security features of SQL Server and how to integrate them with Windows
security. Learn how to diagnose security-related issues and how to set up security, both for a SQL
Server instance running locally, and for others running remotely. Learn how to set many user
permissions at once through the use of server and database roles. Setup and configure enterprise-level
distributed queries by using impersonation and delegation with linked SQL Servers.
Who should take this course?
This course is designed for the students who have a good understanding of the basics of SQL Server
and want to set up both local and remote security structures. This course is designed for database
administrators that will be responsible for setting up and modifying user permissions, changing
object-level securable permissions, and handling security on individual SQL Servers and between
multiple groups of SQL Servers.
• Combine principals, securables, and permissions to implement core enterprise-level
• Integrate the security systems of SQL Server and Windows into one security plan.
• Implement SQL Server security roles.
• Combine and separate SQL Server authentication and Windows authentication.
• Enable and configure the security features that allow you run a query session against multiple
SQL instances by setting up linked servers.
• Length: 20 hours
• Format: Classroom
• Prerequisites: Beginning SQL Server (using 2008) or equivalent
The above prerequisites are considered to be the basic skills and knowledge needed prior to taking
this class. Instructors will assume your readiness for the class materials and will NOT use class time
to discuss prerequisite materials.
SQL Server 2008 Security | Pg. 1
COMPUTER & TECHNOLOGY PROGRAMS
Combine principals, securables, and permissions to implement core enterprise-level
• Setup Windows security using principals, securables, and permissions.
• Setup and test new users with different permission-levels.
Integrate the security systems of SQL Server and Windows into one security plan.
• Setup security at the SQL Server-level.
• Integrate SQL Server-level principals with database-level security.
• Implement object-level security within a SQL database.
• Group securable permission sets using schema-level security.
Implement SQL Server security roles
• Simplify login-based security at the server level by using fixed server roles.
• Simplify SQL user-based security by using fixed database roles.
• Combine explicit permissions and role-based permissions to create the desired level of
Combine and separate SQL Server authentication and Windows authentication.
• Create non-Windows-based SQL logins and enable their use with the proper
• Map non-Windows-based SQL logins to database-level resources.
• Setup database users with different default security schemas.
Enable and configure the security features that allow you run a query session against
multiple SQL instances by setting up linked servers.
• Setup linked servers to run remote and distributed queries.
• Configure security options for linked servers.
SQL Server 2008 Security | Pg. 2