Comments on Curion: Encrypted SQL Server SSIS Configurations

When Wow Gold wolf finally found the wow gold ch...

2009-03-18T05:10:00.000-07:00

When Wow Gold wolf finally found the wow gold cheap hole in the chimney he crawled cheap wow gold down and KERSPLASH right into that kettle of water and that was cheapest wow gold the end of his troubles with the big bad wolf.
game4power.
The next day the Buy Wow Goldlittle pig invited hisbuy gold wow mother over . She said "You see it is just as mygamegoldI told you. The way to get along in the world is to do world of warcraft gold things as well as you can." Fortunately for that little pig, he buy cheap wow gold learned that lesson. And he just k4gold lived happily ever after!.

Using Encrypted configurations is no different tha...

2008-07-23T03:02:00.000-07:00

Using Encrypted configurations is no different than using unencrypted configurations both at run-time and design time. So you can either have specific single configurations or set environment variables to choose your configuration (might be a few others).

The only thing that's important is that whatever account is attempting to access or update the configuration needs to have access.

Having stored your configs in SQL Server how can I...

2008-07-18T16:58:00.000-07:00

Having stored your configs in SQL Server how can I select a config when setting up a job in SQL Server

create the VIEW first and then create INSERT, UPDA...

2008-02-22T10:09:00.000-08:00

create the VIEW first and then create INSERT, UPDATE, and DELETE as triggers for the VIEW. That helps....

Its working now. dont create the triggers on the configuration table. since i was renaming the table to follow our standards i just lost track of where i was creating them

As presented only the accounts in the view will ev...

2008-02-04T13:58:00.000-08:00

As presented only the accounts in the view will ever have access to the data. The "achilles" heel of this is that if a hacker can guess the account names that have access, they can move the database to another network and created accounts with the exact same names to access the data. Otherwise the data won't be accessible.

A better way is to use transparent decryption with certificates. Then without the original password used to add the certificate to the server, no one can access the data.

Great!But one question, how do I prevent others to...

2008-01-31T01:33:00.000-08:00

Great!
But one question, how do I prevent others to access the information throw the view?

Thanks for the excellent article.Saved me a lot of...

2007-12-21T01:00:00.000-08:00

Thanks for the excellent article.

Saved me a lot of time!!