Tài liệu Module 15: Implementing Security pdf

Contents

Overview 1

Introducing Analysis Services Security 2

Understanding Administrator Security 3

Securing User Authentication 5

Understanding Database Roles 6

Implementing Dimension Security 13

Managing Cube Roles 17

Lab A: Implementing Cube Security 27

Review 32

Module 15:

Implementing Security

BETA MATERIALS FOR MICROSOFT CERTIFIED TRAINER PREPARATION PURPOSES ONLY

Information in this document is subject to change without notice. The names of companies,

products, people, characters, and/or data mentioned herein are fictitious and are in no way intended

to represent any real individual, company, product, or event, unless otherwise noted. Complying

with all applicable copyright laws is the responsibility of the user. No part of this document may

be reproduced or transmitted in any form or by any means, electronic or mechanical, for any

purpose, without the express written permission of Microsoft Corporation. If, however, your only

means of access is electronic, permission to print one copy is hereby granted.

Microsoft may have patents, patent applications, trademarks, copyrights, or other intellectual

property rights covering subject matter in this document. Except as expressly provided in any

written license agreement from Microsoft, the furnishing of this document does not give you any

license to these patents, trademarks, copyrights, or other intellectual property.

 2000 Microsoft Corporation. All rights reserved.

Microsoft, BackOffice, MS-DOS, Windows, Windows NT, <plus other appropriate product

names or titles. Replace this example list with list of trademarks provided by copy editor.

Microsoft is listed first, followed by all other Microsoft trademarks in alphabetical order. > are

either registered trademarks or trademarks of Microsoft Corporation in the U.S.A. and/or other

countries.

<This is where mention of specific, contractually obligated to, third party trademarks, which are

added by the Copy Editor>

The names of companies, products, people, characters, and/or data mentioned herein are fictitious

and are in no way intended to represent any real individual, company, product, or event, unless

otherwise noted.

Other product and company names mentioned herein may be the trademarks of their respective

owners.

Module 15: Implementing Security iii

BETA MATERIALS FOR MICROSOFT CERTIFIED TRAINER PREPARATION PURPOSES ONLY

Instructor Notes

In this module, students will gather the skills necessary to implement security in

MicrosoftÆ SQL Serverô 2000 Analysis Services. Students will learn the

concepts and mechanics of administrative permissions, database roles, and cube

roles. In the lab, students create and test a role that uses dimension and cell

security.

After completing this module, students will be able to:

! Understand the use of security in Analysis Services.

! Explain administrator security.

! Describe authentication methods.

! Assign database roles.

! Apply dimension security.

! Manage cube roles.

Materials and Preparation

This section lists the required materials and preparation tasks that you need to

teach this module.

Required Materials

To teach this module, you need the following materials:

! Microsoft PowerPointÆ file 2074A_15.ppt

Preparation Tasks

To prepare for this module, you should:

! Read all the student materials.

! Read the instructor notes and margin notes.

! Complete all the demonstrations.

! Practice the lecture presentation and demonstration.

! Complete the lab.

! Review the Trainer preparation presentation for this module on the Trainer

Materials compact disc.

! Review any relevant white papers that are located on the Trainer Materials

compact disc.

Presentation:

60 Minutes

Lab:

30 Minutes