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
Last activity: Apr 14, 2023, 10:50 PM