The first time you sign into developerWorks, a profile is created for you. Select information in your profile (name, country/region, and company) is displayed to the public and will accompany any content you post. You may update your IBM account at any time.

All information submitted is secure.

The first time you sign in to developerWorks, a profile is created for you, so you need to choose a display name. Your display name accompanies the content you post on developerworks.

Please choose a display name between 3-31 characters. Your display name must be unique in the developerWorks community and should not be your email address for privacy reasons.

All information submitted is secure.

My developerWorks:

My notifications:

Sign out

Select a language:

DB2 9 Fundamentals exam 730 prep, Part 2: Security

Graham G. Milne (gmilne@ca.ibm.com), I/T Specialist DB2 UDB, IBM Canada

Graham Milne, HBSc. - Computer Science, is a DB2 Certified Advance Technical Expert and has been working with DB2 since 1998. Currently Graham is a Premium Support Manager for DB2 supporting large premium customers. Previous to this, he was the senior advanced service consultant for DB2 support based out of the IBM Toronto Software Lab.

Summary: This tutorial introduces the concepts of authentication, authorization, and privileges as they relate to DB2® 9. It is the second in a series of seven tutorials designed to help you prepare for the DB2 9 Fundamentals Certification Exam (730). You should have basic knowledge of database concepts and operating system security. This is the second in a series of seven tutorials to help you prepare for the DB2 9 for Linux®, UNIX®, and Windows® Fundamentals exam 730.

View more content in this series

Date: 20 Jul 2006
Level: Intermediate
PDF: A4 and Letter (505 KB | 32 pages)Get Adobe® Reader®

Activity: 38187 views
Comments:

Before you start

About this series

Thinking about seeking certification on DB2 fundamentals (Exam 730)? If so, you've landed in the right spot. This series of seven DB2 certification preparation tutorials covers all the basics -- the topics you'll need to understand before you read the first exam question. Even if you're not planning to seek certification right away, this set of tutorials is a great place to start getting to learn what's new in DB2 9.

About this tutorial

In this tutorial, you'll learn about DB2 9 security features, including DB2 9 authentication, authorization, and privileges.

This is the second in a series of seven tutorials you can use to help prepare for the DB2 9 Fundamentals exam 730. The material in this tutorial primarily covers the objectives in Section 2 of the test, which is entitled "Security". You can view these objectives at: http://www.ibm.com/certify/tests/.

Prerequisites

To understand the concepts described in this tutorial, you should already have a basic knowledge of database concepts and an understanding of operating system security features.

System requirements

The examples in this tutorial are specific to DB2 9 running on a Windows® operating system (with native security features). However, the concepts and information provided are relevant to DB2 running on any distributed platform.

You do not need a copy of DB2 9 to complete this tutorial. However, you will get more out of the tutorial if you download the free trial version of IBM DB2 9 to work along with this tutorial.

Setup

To complete the steps in this tutorial, you should have:

Logged into a Windows machine as a user who is a member of the Administrators group. In the examples in this tutorial, we will be logged in with the user ID gmilne.
Installed DB2 9.
Created a new group on the machine on which DB2 was installed. In this tutorial, the group ID db2grp1 is used.
Created a second user ID on the machine on which DB2 was installed. In this tutorial, for this purpose we will use the user ID test1. Note that the test1 user is not a member of the Administrators group.