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 https://learn.microsoft.com/en-us/sql/t-sql/statements/revoke-transact-sql?view=sql-server-ver16