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

	Grant to database users and roles the appropriate permissions on database objects and statements
	Audit server and database activity

Permissions

	Introduction to permissions
	Assigning permissions
	Understanding permission precedence

Permission Management Tools

	Using views and stored procedures
	Understanding ownership chains
	Best practices for managing permissions

Displaying Permissions Information

	Viewing statement permissions
	Viewing a user's object permissions
	Viewing an object's permissions

Granting and Revoking Permissions

	Statement permissions
	Object permissions
	Managing permissions with Transact-SQL

Auditing Server and Database Activity

	About SQL Server Profiler
	Setting Profiler defaults
	Setting Profiler options
	Running a Profiler trace

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)
	SQL Server 7 Admin: Managing Accounts (LA7C09)

Microsoft® is a registered trademark of Microsoft Corporation.