Docstoc

SQL Server 2008 Security

Document Sample
SQL Server 2008 Security Powered By Docstoc
					                 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.

          Course Objectives
                 •	 Combine principals, securables, and permissions to implement core enterprise-level
                    security strategies.
                 •	 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.

          Course Details
                 •	 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



          Course Contents

               Combine principals, securables, and permissions to implement core enterprise-level
               security strategies.
                 •	 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
                    effective permissions.

               Combine and separate SQL Server authentication and Windows authentication.
                 •	 Create non-Windows-based SQL logins and enable their use with the proper
                    authentication mode.
                 •	 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

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:4
posted:10/3/2011
language:English
pages:2