This chapter will introduce you to Db2 security features, including roles, trusted contexts, trusted connections, row and column access control, and Db2 native encryption. You will learn to use Lightweight Directory Access Protocol (LDAP)-based authentication through the LDAP security plugin module. You will also be introduced to the Db2 audit facility to generate and maintain an audit trail for a series of predefined database events.
After the completion of this chapter, you will demonstrate the ability to:
- Understand the authentication and authorization levels used by Db2
- Configure and use transparent LDAP authentication
- Create and use trusted contexts and trusted connections in a three-tier application system
- Implement row or column permissions by using row and column access control (RCAC)
- Encrypt data in-transit using SSL, and encrypt data at rest using Db2 native...