Security and Compliance Solutions for IBM Informix Dynamic Server

An IBM Redbooks publication

Note: This is publication is now archived. For reference only.

Published 07 March 2008

cover image

ISBN-10: 0738485721
ISBN-13: 9780738485720
IBM Form #: SG24-7556-00
(314 pages)

More options

Rate and comment

Authors: Whei-Jen Chen, Holger Kirstein, Ravi Pachipala, Vaibhav S Dantale


In this IBM Redbooks publication, we discuss, in detail, the security features available in IBM Informix Database Server (IDS). These enriched IDS security features provide you with the capability to protect your data and comply with regulatory requirements.

We discuss how IDS integrates with operating system security functions for user authentication and user permissions. The role separation divides the security duty among administrators. Auditing enables the database server to log sensitive operations performed by users and administrators for analysis and identifying system misuses.

Discretionary access control (DAC) is the primary access control mechanism that enables access to SQL objects using privileges and roles. Using label-based access control (LBAC), you can control read and write access of users to individual rows and columns at the table level. We then discuss how to secure server-server and server-client communication in an IDS environment, as well as address the security issues for backup and restore.

Table of contents

Chapter 1. Technology overview
Chapter 2. Role separation
Chapter 3. Auditing
Chapter 4. Securing data with SQL
Chapter 5. Client-server communication
Chapter 6. Server-server communication
Chapter 7. Security issues with backup and restore
Appendix A. Audit event mnemonics
Appendix B. PAM API and macros

Follow IBM Redbooks

Follow IBM Redbooks