This is a read-only copy of the MariaDB Knowledgebase generated on 2024-11-15. For the latest, interactive version please visit https://mariadb.com/kb/.

Mask every column in all tables of a DataBase and specify which not

What I am looking for is to mask all the columns (and new columns that could be added in the future to the tables in my DB).

So for that I want to know if there is a way to mask everything and specify which column names to be excluded of masking.

What I have tried is the following:

{
    "rules": [
        {
            "replace": {
                "database":"myDB",
		"match":"\\s+(.*)"
            },
            "with": {
                "fill": "X"
            }
        }
    ]
}

But I get the error:

Error: Server at http://myhost:4919 responded with 400 Bad Request to `POST filters`
{
    "errors": [
        {
            "detail": "A masking rule 'replace' does not have the mandatory 'column' key or it's not a valid Json string."
        }
    ]
}
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.