Activates Dynamic Data Masking (DDM) for a database after the database is enabled for DDM. This option requires a DDM license.

Syntax

proutil db-name -C activateddm [-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

  • You must enable DDM before activating it. The database must be in the DDM-enabled and deactivated state for DDM activation to complete.

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

  • When DDM is successfully activated, all connected and authenticated users and clients are notified. ACTIVATEDDM ensures that the DDM policies you have set up are honored. You can now apply masking rules on designated columns. All connected clients must comply with the policies and masking rules that have been set up.
  • In a replication plus deployment, the replication agent notifies all replication targets about the DDM policies.
  • After you activate DDM, the PROUTIL DESCRIBE qualifier reports DDM as active.
  • ACTIVATEDDM is an auditable event if your database is enabled and configured for auditing.
See: