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 10.1 DBA for Linux, UNIX, and Windows certification exam 611 prep, Part 7: Security

Piotr Pruski (piotr.pruski@ca.ibm.com), Technical Enablement Specialist, IBM

Piotr Pruski is a technical enablement specialist within the Information Management Technology Ecosystem team in IBM. He works with various platforms such as operating systems, virtualization technologies, and hardware to integrate and automate IBM software products with partner solutions. One such example is the IBM Smart Analytics System 5710, which is part of the IBM Big Data Analytics portfolio. As a certified DB2 database administrator, he has also traveled worldwide to engage and train IBM business partners and clients on IM products as well as aiding in developing educational material.

Andre Albuquerque (andreda@ca.ibm.com), Technical Enablement Specialist, IBM

Andre Albuquerque is a technical enablement specialist within the Information Management Technology Ecosystem team in IBM. Before joining IBM Canada Labs, Andre had been working for many years as a systems analyst and software developer for private companies in Brazil. Andre joined IBM Canada Labs in 2009 and works with various IBM products such as DB2 and InfoSphere BigInsights. As an advanced certified DB2 database administrator, he is the content owner of DB2 Bootcamps and Big Data Fundamentals Bootcamp. He traveled worldwide to engage and train IBM business partners and clients on DB2.

Summary: This tutorial introduces the concepts of authentication, authorities, privileges, audit facility, trusted context, RCAC, and LBAC as they relate to DB2® 10. It is the seventh in a series of tutorials designed to help you prepare for the DB2 10.1 for Linux®, UNIX®, and Windows® Database Administration (exam 611). You should have basic knowledge of database concepts and operating system security.

View more content in this series

Date: 06 Dec 2012
Level: Intermediate
PDF: A4 and Letter (509 KB | 29 pages)Get Adobe® Reader®

Activity: 5444 views
Comments:

Before you start

About this series

If you are preparing to take the DB2 10.1 for Linux, UNIX, and Windows DBA certification exam (exam 611), you've come to the right place — a study hall of sorts. This series of "DB2 10.1 DBA certification exam 611" tutorials covers the major concepts you'll need to know for the test.

About this tutorial

You'll learn about DB2 10.1 security features, including label-based access control, and the new row and column access control.

This is the seventh in a series of tutorials you can use to help prepare for the DB2 10.1 DBA for Linux, UNIX and Windows exam 611. The material here primarily covers the objectives in Section 7 of the test, titled "Security." You can view the objectives.

Prerequisites

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

System requirements

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

The examples in this tutorial are specific to DB2 10.1 running Linux with native security features. However, the concepts and information provided are relevant to DB2 running on any distributed platform.

Comments