Let's Say that I use an Encrypted Pwd.

1. Does SQL have a way to internally Decrypt The Pwd?

2. If I have to Write a Class to Decrypt it, them...

Still, If I can Access the Store Procedure from Another App (ex: Access) I can push incorrect data or modify data with no integrity.

BTW, there is a problem with windows authentication. If the user has access he can use Excel and update the information from it and that is why I do not...

How else can it be done w/o using Windows Authentication?