After completing SQL Server 7 Admin: Managing Accounts the user should be able to:

	Create and assign SQL server roles
	Manage login IDs and database User IDs

Viewing ID Information

	Displaying SQL Server account information
	Viewing login ID information
	Viewing database user ID information

Viewing Roles

	Viewing database role information
	Viewing server role information

Managing Login IDs

	Creating login IDs
	Configuring login IDs
	Deleting login IDs

Managing Database IDs and Roles

	Creating and configuring database user IDs
	Creating database roles
	Deleting database user IDs or database roles

Server Roles and Management Procedures

	Assigning a server role
	System stored procedures
	Creating and managing IDs and roles

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)
	SQL Server 7 Admin: Security Management (LA7C08)

Microsoft® is a registered trademark of Microsoft Corporation.