Blog Post

Modernization Best Practices and Reusable Assets Blog
2 MIN READ

Implementing Oracle Data Masking capabilities in Azure PostgreSQL- Flexible Server

VenkatMR's avatar
VenkatMR
Icon for Microsoft rankMicrosoft
Sep 26, 2024
Introduction Dynamic data masking is essential when sensitive information, such as PII, needs to be protected while sharing data with third parties or during the transfer of data from production to...
Updated Sep 27, 2024
Version 4.0
database platform cse
database platform cse - azure postgresql
database platform cse – oracle
mimamar's avatar
mimamar
Copper Contributor
Nov 07, 2024

The above guide works if the public schema is used. What needs to be done that another schema can be used?

When executing 

ALTER DATABASE mydatabase SET anon.sourceschema TO 'myschema';

I get

[42501] ERROR: permission denied to set parameter "anon.sourceschema"

 

  • VenkatMR's avatar
    VenkatMR
    Icon for Microsoft rankMicrosoft
    Feb 04, 2025

    The ALTER DATABASE option is not available yet, it is in progress, will share the update once available

    • hgeorgilas's avatar
      hgeorgilas
      Copper Contributor
      Jul 23, 2025

      ​ VenkatMR​ Any news on this? Using this extension with 

      SELECT anon.start_dynamic_masking();

      Instead of setting this on the database level makes this extension almost worthless in the context of Azure Flexible Server.

      • VenkatMR's avatar
        VenkatMR
        Icon for Microsoft rankMicrosoft
        Aug 10, 2025

        Still in progress, will update once the feature is available