Deactivates Dynamic Data Masking (DDM) feature from a DDM-enabled database. This option does not require a DDM license.

Syntax

proutil db-name -C deactivateddm [-U userid -P password]

Parameters

db-name
Specifies the database you are using.
-U userid -P password

Specifies the user ID and password of an authenticated DDM or security administrator.

Notes

  • For successful DDM deactivation, the database must be in the DDM-enabled and activated state.

  • Only a DDM administrator, or if there is no DDM administrator, an ABL security administrator or SQL DBA, can run DEACTIVATEDDM.

  • After DDM is successfully deactivated, all connected and authenticated users and clients are notified. All connected clients ignore the DDM policies and masking rules that have been set up.
  • In a replication plus deployment, the replication agent notifies all replication targets about DDM deactivation.
  • After you deactivate DDM, the PROUTIL DESCRIBE qualifier reports DDM as enabled and inactive.

  • DEACTIVATEDDM is an auditable event if your database is enabled and configured for auditing.

See: