using logins

From: Jason (jlewis_at_homail.com)
Date: 02/10/05 

Date: Thu, 10 Feb 2005 07:43:08 +0100

Hello,

I'm currently developing an access application which uses sql server as a
backend.

What i'm uncertain about, is how i should setup security without creating
too many sql server logins. I'm convinced that i should limit access to sql
server, otherwise people can get in with other means than my application
(e.g. odbc, sem, etc.).
I've setup sql server in mixed mode and created a login for my application
to connect to a database.

So, what is the best way to implement tight security, but still be able to
log the current user and hostname? If a separate table is needed to created
users and passwords, please tell me how to use it, i've never done that
approach.

Thnx 

-- 
----------------------------------------------------
This mailbox protected from junk email by MailFrontier Desktop
from MailFrontier, Inc. http://info.mailfrontier.com

Relevant Pages

  • SQL Server Security
    ... New to SQL Server. ... I need to setup security where our network admin is ...
    (microsoft.public.sqlserver.security)
  • Re: ODBC Security
    ... If SQL server then you can use windows integrated or sql server logons, if Access then you setup security in the access database, etc. etc. ... Dave Patrick ....Please no email replies - reply in newsgroup. ...
    (microsoft.public.windows.server.general)
  • End User Security Administrator for a Intranet Application
    ... This will involve creating sql server logins and ... administrator needs the SQL server fixed server ... I really don't want to give end users the sysadmin fixed ...
    (microsoft.public.sqlserver.security)
  • Re: access deny the sa account
    ... > authority, is it possible to disable the account sa to access the ... not with SQL Server logins. ... Andrea Montanari (Microsoft MVP - SQL Server) ...
    (microsoft.public.sqlserver.msde)
  • Re: Cross VPN Domain Authentication
    ... around having to maintain those SQL Server logins and the user ambiguity ... SQL Server DBA ... Children's Oncology Group ...
    (microsoft.public.sqlserver.security)
Quantcast