HOW TO ENCRYPT AND DECREYPT PASSWORD BY USING ENCRYPTBYPASSPHRASE AND DECRYPTBYPASSPHRASE IN MSSQL

[@dhanarajumattaparthi6399]

Nice...thanks for sharing knowledge on this

[@ssunitech6890]

Thanks for your appreciation

[@mohimakhter258]

That's Great, But how can we create the private key of users

[@sidharthabehera4915]

How to use Encrypt password in stored procedure please make a video

[@ssunitech6890]

Sure, will record a video on this.

[@landchennai8549]

How it differ from dynamic data masking?

[@ssunitech6890]

In DDM, it doesn't actually change in the table values. While selecting data for specific users you would see masked values. And admin user can revoke grand access and user can see the data. In case of encryption it is used to encrypt the values in the table. Thanks