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.

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