Application Roles

From: Gary Murphy (
Date: 12/17/02

From: "Gary Murphy" <>
Date: Tue, 17 Dec 2002 05:44:03 -0800

I have a question concerning SQL Server Application
roles. I want to use application roles in a new
application we are developing inorder to prevent users
from using tools like SQL analyzer or MS access from
accessing the database directly.

I don't like the idea of hardcoding a password in the
application code for the application role.

Any suggestions on how I can use "application roles" and
somehow encrypt the password so it doesn't show up in the
application code?