Administrator Guide

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

Back Next

Greenplum Connections

Configure database privileges and impersonation and cleanup commands for a Greenplum 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 Greenplum database:

SET ROLE \(AUTH_USERNAME)
SET SEARCH_PATH = \(AUTH_CURRENT_SCHEMA)

Required Database Privileges

The Dynamic Data Masking administrator must have the following privilege:

GRANT <client_username> TO <ddm_username>

The database user that Dynamic Data Masking impersonates must have the following privilege:

GRANT SELECT ON TABLE <tablename> TO <client_username>;

Cleanup Commands

You might enter the following commands in the

Cleanup Commands

text box for a Greenplum database:

RESET ROLE;
RESET SEARCH_PATH;

Rename Saved Search

Table of Contents

Administrator Guide

Administrator Guide

Greenplum Connections

Greenplum Connections

Impersonation Commands

Required Database Privileges

Cleanup Commands