Articles & Content

Archives

Trusted Contexts and Roles in a Web Application (H04)

Topic: DB2 for LUW

Subtopic: 2008



DATE: 2008-5-19 (04:00 PM - 05:00 PM)
SPEAKERS: Matt Eakle (S1 Corporation)

Among the new features in DB2 V9.5 (Viper 2) are Roles and Trusted Contexts. Roles simplify the management of privileges in a database. Trusted Contexts are new objects that enable database connections via explicit trusted connections, providing stronger security in a number of ways. S1 Corporation experimented with both new objects in its Enterprise Banking product to see if the features could make administration easier, improve security, and be used to provide stronger application logging. This presentation will examine how S1 Enterprise implemented Roles and Trusted Contexts, help determine if they make sense for your application, and explore their pros and cons.

EXP. LEVEL: Beginner,Intermediate

OBJECTIVES:

Explore the concepts and value behind both Roles and Trusted Contexts. What voids do they fill?

Learn how to create and use both types of objects, especially the way Roles are leveraged in Trusted Contexts. Present the syntax of commands used to manipulate both new objects.

Demonstrate how the S1 Enterprise application connected to the database prior to the introduction of Trusted Contexts, and the code changes required to connect from the application server to the database using Trusted Contexts.

Present examples of the new capabilities when connecting through Trusted Contexts, including the ability to change attributes (and Roles) on the fly.

Show how the trace logging generated by the S1 Enterprise application can be enhanced by including more detailed user information (more is better when troubleshooting).



Click Here to Download

NOTE: These are only open to members of IDUG. If you are not a member, please CLICK HERE for more information.