Re: ISV Using SQL Authentication - a login concern

From: Jasper Smith (jasper_smith9_at_hotmail.com)
Date: 05/26/04


Date: Wed, 26 May 2004 17:41:35 +0100

To add to Geoff's excellent points, why does your application need sysadmin
priviliges ? You really need to try and use a login with minimal priviliges
and just the required rights in the database(s) it uses. Have a look at
http://www.microsoft.com/sql/techinfo/administration/2000/security/default.asp

-- 
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"dev" <anonymous@discussions.microsoft.com> wrote in message
news:BEEEFD7D-7EA8-4858-812E-E61C46C8C9A6@microsoft.com...
> thanks Geoff, I appreciate your reply.  You said it is not very secure..
do you mean from external attacks or internal user issues.. what kind of
general problems I can expect to encounter.
>
> Thanks