A MASKING POLICY was created as a substitute for MASKED WITH.
This EWI is added when the Alter Table statement contains a MASKED WITH clause. The reason this is added is to inform that an approximate MASKING POLICY was created as a substitute for the MASKED WITH function.
ALTER TABLE table_name
ALTER COLUMN column_name
ADD MASKED WITH (FUNCTION = 'default()');
ALTER TABLE IF EXISTS table_name
MODIFY COLUMN column_name
/*** MSC-WARNING - MSCEWI4056 - A MASKING POLICY WAS CREATED AS A SUBSTITUTE FOR MASKED WITH ***/
SET MASKING POLICY "default";
The MASKING POLICY will be created previous to the ALTER TABLE statement. And it is expected to have and approximate behaviour. Some tweaks might be needed in regards to roles and user privileges. You can relate to MSCEWI4057 for further details.
- For more support, you can email us at [email protected] or post a message to our forums. If you have a contract for support with Mobilize.Net, reach out to your sales engineer and they can direct your support needs.