Preface
Introduction to Dynamic Data Masking Administration
Authentication
Connection Management
JDBC Client Configuration
ODBC Client Configuration
- ODBC Client Configuration Overview
Access Control
Logs
High Availability
Server Control
Performance Tuning

Administrator Guide

9.8.0
- 9.9.4
- 9.9.3
- 9.9.2
- 9.9.1
- 9.9
- 9.8.4
- 9.8.3
- 9.8.2
- 9.8.1

Back Next

DB2 Database Administrator Required Privileges

The database administrator must have privileges to access sensitive tables and columns.

Use the DB2 Control Center to create a privileged user, <DBA Username>, that corresponds to an administrator user on your operating system.

Run the following command from an SQL window:

GRANT SETSESSIONUSER ON PUBLIC TO <DBA Username>

If the DB2 database is encrypted and uses an ODBC driver, to allow impersonation, the database administrator must have the following privilege to access the database table:

SYSIBMADM.SNAPAPPL_INFO

Rename Saved Search

Table of Contents

Administrator Guide

Administrator Guide

DB2 Database Administrator Required Privileges

DB2 Database Administrator Required Privileges