Table of Contents

Search

  1. Preface
  2. Introduction to Dynamic Data Masking Administration
  3. Authentication
  4. Connection Management
  5. JDBC Client Configuration
  6. ODBC Client Configuration
  7. Access Control
  8. Logs
  9. High Availability
  10. Server Control
  11. Performance Tuning
  12. Troubleshooting

Administrator Guide

Administrator Guide

Netezza Connections

Netezza Connections

Configure database privileges and impersonation and cleanup commands for a Netezza database.
The required user privileges and commands for impersonation and cleanup vary based on the database and database version. The following privileges and commands are examples that work for some versions of the database.

Impersonation Commands

You might enter the following commands in the
Impersonation Commands
text box for a Netezza database:
SET CATALOG \(AUTH_CATALOG) SET SCHEMA \(AUTH_CURRENT_SCHEMA) EXECUTE AS \(AUTH_USERNAME)

Required Database Privileges

The Dynamic Data Masking administrator must have the following privileges:
GRANT CONNECT ON <database_name> TYPE DATABASE TO <ddm_username>; GRANT CONNECT ON <schemaname> TYPE SCHEMA TO <ddm_username>; GRANT EXECUTE AS ON <client_username> TYPE USER TO <ddm_username>

Cleanup Commands

You might enter the following commands in the
Cleanup Commands
text box for a Netezza database:
SET CATALOG \(ADMIN_CATALOG) REVERT

0 COMMENTS

We’d like to hear from you!