Forum Discussion
Data masking in SQL server 2019
We tried to mask a column in SQLDB I first backup the table tblContacts to tblContacts_backup then I issue following SQL command to mask the column "Email" ALTER TABLE tblContacts ALTER COLUMN E...
Use `DENY` instead of `REVOKE`.
Their are quite different but often make confused.
`DENY` means refuse somebody to do something. That very clear.
`REVOKE` is complicated, normally, it means cancel all `DENY` or `GRANT` assigned somebody on something before. Check this document REVOKE (Transact-SQL) - SQL Server | Microsoft Learn
