Administrator Guide

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

Back Next

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

Rename Saved Search

Table of Contents

Administrator Guide

Administrator Guide

Netezza Connections

Netezza Connections

Impersonation Commands

Required Database Privileges

Cleanup Commands