SQL Security

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Patman (p_hoard_at_yahoo.com)
Date: 03/30/04 

Date: 30 Mar 2004 12:28:53 -0800

I'm kind of new to SQL so if this question has been answered recently
I apologize.

I have a login script that caputures user and computer info and writes
it to a SQL db. To avoid a login/password in my text logon script I
using a trusted connection with "Domain users" having
select/insert/update permissions in the db. My problem is that any
authenicated user can view this data from Access, SQL Enterprise
Manager, etc.

Is is possible to restrit this db so that authenicated users can still
select/write to the db but not be able to view from other ODBC related
sources?

TIA,
Pat

Relevant Pages

  • Re: SQL Security
    ... Here is a snippet from Books Online (within the SQL Server program group): ... > I have a login script that caputures user and computer info and writes ... > select/insert/update permissions in the db. ... > authenicated user can view this data from Access, ...
    (microsoft.public.sqlserver.server)
  • RE: SQL Security
    ... Use Windows authentication on SQL connection in login script. ... (Users cannot capture LOGIN NAME and PASSWORD from login script) ...
    (microsoft.public.sqlserver.server)
  • Parsing Domain Groups with .NET
    ... authenicated user is in when they login/navigate through ... get that info (Domain Admins and SQL DBA's) on the groups ...
    (microsoft.public.dotnet.security)