Designing and Implementing Security in SQL Server 2000

This course is included in our On-demand training solution.


To use programming logic to implement security and describe the different levels of security

Target Audience

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


Experience working in a medium to enterprise computing environment that uses SQL Server 2000 Enterprise Edition; at least one years experience administering SQL Server; at least one years 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

70 min.

Course Objectives

Designing and Implementing Security in SQL Server 2000

  • provide an overview of SQL Server security and discuss the authentication modes.
  • describe server and object-level security.
  • implement object-level security.
  • control the access of data using stored procedures, user-defined functions, and views.
  • describe and implement ownership chains.