After completing SQL Server 7 Admin: Security Strategy the user should be able to:

	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

SQL Server Authentication Methods

	Developing a security strategy
	SQL Server authentication methods
	Choosing an authentication method

Using Windows NT Groups

	Planning the use of Windows NT groups
	Using SQL Server login IDs

Planning the Use of SQL Server Roles

	SQL Server permission pyramid
	Assigning logins to roles
	NT global groups for database access
	Logins and database user accounts

Developing a Security Strategy

	Security with views
	Security with stored procedures
	Managing security with application roles

Other Security Issues

	Choosing a startup account
	Linked databases in security planning

This course has the following features:

	Exercises that allow users to practice the skills needed to develop a security strategy for SQL Server 7.0
	A file containing the text of the exercises
	Activities that allow users to apply concepts in an interactive questioning environment
	A glossary
	A Skill Assessment

	Courses on Relational Database Management Systems or equivalent experience
	Courses on Windows NT administration or equivalent experience
	Courses on Database Concepts or equivalent experience
	Courses on SQL or equivalent experience

Microsoft® is a registered trademark of Microsoft Corporation.