Sample Header Ad - 728x90

Application Role - Reset Password using hash or Encryption form

0 votes
0 answers
60 views
I need to automate reset password of database application role. Password must be encrypted or hash form due to security reason. I tried to convert password in hash form using 'Hashbytes' as mentioned below but didn't work. SELECT HASHBYTES('SHA2_256','PASSWORD') GO USE GO ALTER APPLICATION ROLE [approle_name] WITH PASSWORD= 'password hash value' GO I have investigated around password reset of application role but no much able to find out Are you able to help how can I achievement it or is it possible to do so? Thanks in Advance sonny
Asked by SQLHoncho (1 rep)
Feb 10, 2023, 07:07 AM
Last activity: Apr 14, 2023, 10:50 PM