x

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

DirkHondong
1.3k 15 17 19

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

1 answer: sort voted first
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

By RSS:

Answers

Answers and Comments

SQL Server Central

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

Topics:

x69
x15
x2

asked: Apr 03, 2012 at 10:43 AM

Seen: 884 times

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