How do you secure a column of data in a hosted one organization database

I've seen ASP.NET developers saying good things about DynCrypto for this sort of thing:
http://www.dyncrypto.com/default.htm

If it works from a hosted /bin/ folder you should be all set.

Note: DASP allows us to create additional DB logins...
You should be able to create a role for Table Reader, create the new login and assign the Table Reader role you created.
I haven't done that here but since we can create new logins it should work.


Post Edited (wisemx) : 2/11/2008 1:53:12 PM GMT

 

I'm hoping for some suggestions or thought on this.

The app and database are being used by one organization.

I want to protect a column in a table, so currently I setup a pass phrase that is stored in a table. The stored procedures using this column get the pass phrase from the table and use it to encrypt and/or decrypt to column when it is saved, viewed, or updated.

The application may be used by others at some point all having their own databases.

I'm not sure what type if any security is provided by discountasp, so I just wanted to get a thought or two on the process above and if it will really provide any security.

Thank you,