No, it means you put each user into a "MyAppDbAccess" NT group, then in SQL assign that group as the login.
Adam.. -----Original Message----- From: Unmoderated discussion of advanced .NET topics. [mailto:[EMAIL PROTECTED] On Behalf Of Eddie Lascu Sent: Thursday, December 09, 2004 10:29 AM To: [EMAIL PROTECTED] Subject: Re: [ADVANCED-DOTNET] How and where to store securely a database connection string > The account accessing the database will be the one the process is running under... Doesn't that mean you need to have database accounts for every user? Adding new users to the system will include the creation of a new account in the database which I guess transfers responsibility over to the SysAdmin/DBA. For huge systems, with multiple databases and tens to hundreds of users, this adds an extra level of complexity, when it comes to administration. For small systems with less users I guess it's a viable and interesting solution. =================================== This list is hosted by DevelopMentor� http://www.develop.com Some .NET courses you may be interested in: Essential .NET: building applications and components with C# November 29 - December 3, in Los Angeles http://www.develop.com/courses/edotnet View archives and manage your subscription(s) at http://discuss.develop.com
