I need to give the below script which contains CREATE CREDENTIAL query to an app team.
CREATE CREDENTIAL crdn1 WITH IDENTITY = '<service_acct>',
SECRET = '<pwd>'
GO
My concern is i don't want the password to be visible. Basically i want to use this credential to create a proxy which is then used to run SQL Agent backupjob on number of SQL servers. The statistics of this backup job will then be pushed to another central server database where this same service_acct also allows it to connect and populate a table there.
Is there any way to mask the password OR any other alternative solution.