Audience

IT professionals including database administrators, application developers, independent software vendors, IS managers, system integrators, and Internet consultants who want to plan, deploy, configure, administer, and troubleshoot SQL Server 7.0

Prerequisites

Experience of configuration and administration of Windows NT, familiarity with the Windows 95 or Windows NT user interface, familiarity with managing end-user accounts in an NT environment, knowledge of SQL or Transact-SQL, and an understanding of the role of a database administrator

Course Aim

To enable students to effectively employ and administer security in SQL Server 7.0

Learning Objectives

Identify the principal components and concepts in SQL Server 7.0?s security architecture. Explain SQL Server 7.0?s authentication methods and security modes. Show how to create and manage logins. Describe how to assign database access to NT and SQL Server accounts. Outline how to assign logins to fixed server and fixed database roles. Point out how to create and manage custom roles. List the three types of permission in SQL Server 7.0. Describe how to assign statement and object permissions to users, groups, and roles. Discuss how to implement application-level security using views, stored procedures, application roles, and MTS roles. Summarize how to plan database security in SQL Server 7.0.

Topics Covered

Security basics - Security overview - Security modes - Creating SQL Server logins - Adding a SQL Server login - Managing NT and SQL Server logins - Hands-on: Assigning access to logins Users and roles - Managing database users - Hands-on: Managing database access - Roles - Implementing roles Permissions - Permissions for users and roles - Assigning permissions - Hands-on: Managing permissions Advanced security - Application security - Hands-on: Creating views and roles - Planning security

| About Eno.com | Security&Privacy | Contact Us |
Copyright © 1998-2001 E&A Inc.. All rights reserved.