How 2 change approle password and store it NOT in plain text?

Hi there,

just a quick question to gather some ideas. There´s the need to change the password of an application role. Is there any way to store the new password not in plain text in the update script?

Best regards Dirk
more ▼

asked Apr 03, 2012 at 10:43 AM in Default

DirkHondong gravatar image

1.3k 15 17 19

(comments are locked)
10|1200 characters needed characters left

1 answer: sort oldest
You can certainly use some programming language and make an executable file. SQL Packager is a good tool that can be helpful. You would be able to make an EXE file or open it as 2 C# project. But still the command could be traceable with use of Profiler etc.
more ▼

answered Apr 03, 2012 at 11:25 AM

Usman Butt gravatar image

Usman Butt
13.9k 6 8 14

If you use ALTER APPLICATION ROLE, then the password will not be shown in the profiler.
Apr 03, 2012 at 12:50 PM Pavel Pawlowski
(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: Apr 03, 2012 at 10:43 AM

Seen: 880 times

Last Updated: Apr 03, 2012 at 12:50 PM