Security in a Microsoft SQL Server 2000 Environment

Overview/Description
To explain how to plan and implement security on a SQL 2000 database

Target Audience
Database administrators, application developers, system administrators, and students preparing for Microsoft certification in installing, configuring, and administering Microsoft SQL Server 2000 Enterprise Edition

Prerequisites
Experience working in a medium to enterprise computing environment that uses SQL Server 2000 Enterprise Edition; at least one year’s experience administering SQL Server; at least one year’s experience implementing relational databases in environments that contain heterogeneous databases, SQL Server security integrated with Windows Authentication, client/server configurations of 50 to 50,000 or more users, web configurations that use Internet Information Services (IIS) or COM+, databases as large as 2 TB, and multiple installations of SQL Server 2000

Expected Duration
120 Minutes

Objectives:

Security in a Microsoft SQL Server 2000 Environment

  • describe SQL Server security architecture and SQL Server logins.
  • create a new SQL Server 2000 login account and change a server's authentication mode.
  • administer SQL Server 2000 users, roles, and permissions.
  • assign a login to a role.
  • set permissions in a database.
  • set user permissions for tables and columns in a database.
  • plan security implementation for SQL Server 2000.
  • describe security audits that can be implemented using SQL Profiler and SQL Profiler traces.
  • implement a security audit using SQL Profiler or SQL Trace.
  • implement a security audit using SQL Profiler.


    • Course Number: 31499_eng