Microsoft SQL Server 7 Admin, Config, Install Series: Security Strategy
Product Code: la7c01 Time: 3.0 hour(s) CEUs: Available

Summary:

This course shows users how to plan the security policies for a SQL Server 7 installation.

Objectives:

  • Assess whether to use Microsoft Windows NT or Microsoft SQL Server accounts
  • Decide whether to use the Windows NT group structure for a SQL Server 7.0 installation
  • Plan the use and structure of SQL Server roles
  • Assess whether to map Windows NT groups directly into a database or use SQL Server logins
  • Choose which NT accounts will be used to run SQL Server services
  • Plan an n-tier application security strategy and determine whether to use application roles or other mid-tier security mechanisms such as Microsoft Transaction Server
  • Plan the security requirements for linked databases


Topics:

  • SQL Server Authentication Methods
  • Using Windows NT Groups
  • Planning the Use of SQL Server Roles
  • Developing a Security Strategy
  • Other Security Issues

Technical Requirements:

Minimum 500MHz Processor; 128 MB RAM; Minimum display resolution 1024x768; Windows 2000, XP, Vista, 7 or Mac OS X v10.4+; Internet Explorer 7.0+ or Firefox 3.0+ or Chrome 3.0+ or Safari 4.0+. 56K minimum connection; Adobe Flash Player 9.0+ or Windows Media Player 9.0+ for IE users who do not have Adobe Flash Player; JavaScript, popup windows and cookies enabled; Sound card with speakers or headphones strongly recommended.



Copyright © 2011 MindLeaders. All rights reserved.