Microsoft SQL Server 7.0: Security

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

Target Audience
IT professionals including database administrators, application developers, independent software vendors, 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

Expected Duration
4:00 Hours

Objectives:

Microsoft SQL Server 7.0: Security

  • To identify the principal components and concepts of SQL Server 7.0's security architecture
  • To explain how to access a database and how to use fixed and custom roles in SQL Server 7.0
  • To assign and manage permissions for users and roles in SQL Server 7.0
  • To introduce security planning, application security, and the creation of views and roles


    • Course Number: SQ7027E