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

	Assign SQL Server access through Windows NT accounts SQL Server logins and built-in administrator logins
	Assign database access to Windows NT accounts SQL Server login accounts the Guest account and the DBO user account
	Create and assign SQL Server roles

Overview of SQL Server Security

	Overview of authentication in SQL Server
	SQL Server security planning issues
	SQL Server security terminology
	Barriers to accessing SQL Server data

Security Modes

	User connection types
	Windows NT Server authentication mode
	Mixed Mode
	Configuring Windows NT authentication mode

Creating and Managing Logins

	Creating user logins
	Excluding NT users from SQL Server
	Managing logins for administrators

Database User IDs and Roles

	Creating and managing database user IDs
	Managing SQL Server roles

Using the Create Login Wizard

	About the Create Login Wizard
	Creating standard logins
	Creating logins for NT users
	Creating logins for NT global groups
	Reasons for excluding an NT user
	Excluding NT users

This course has the following features:

	Exercises that allow users to practice in SQL Server 7.0
	A file containing the text of the exercises
	Simulations that allow users to practice course skills even if they don't have access to SQL Server 7.0
	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
	SQL Server 7 Admin: Security Strategy (LA7C01)
	SQL Server 7 Admin: System Requirements (LA7C02)
	SQL Server 7 Admin: Migration Planning (LA7C03)
	SQL Server 7 Admin: Replication Plans (LA7C04)
	SQL Server 7 Admin: Installing the Server (LA7C05)
	SQL Server 7 Admin: Other Installations (LA7C06)
	SQL Server 7 Admin: Configuring (LA7C07)

Microsoft® is a registered trademark of Microsoft Corporation.