Re: security

From: Orko On (orkunon@hotmail.com)
Date: 01/17/03 

From: "Orko On" <orkunon@hotmail.com>
Date: Fri, 17 Jan 2003 20:44:31 +0200

the problem is not getting file. i don't want customer to see my db tables,
views and procedures. administrator is customer not me.

it seems this is impossible with sql.

thanks

"Dejan Sarka" <dejan_please_reply_to_newsgroups.sarka@reproms.si> wrote in
message news:e9QckBivCHA.2592@TK2MSFTNGP10...
> > for example if i install msde on windows 2000 and then some get the
files
> > from network and attach it to a sql on windows 98 my db security breaks.
> > right ?
>
> Use NTFS security and nobody won't get the files. Security can't be done
on
> the database level only, you have to consider all parts of the system.
>
> --
> Dejan Sarka, SQL Server MVP
> FAQ from Neil & others at: http://www.sqlserverfaq.com
> Please reply only to the newsgroups.
> PASS - the definitive, global community
> for SQL Server professionals - http://www.sqlpass.org
>
>

Relevant Pages

  • Re: How to SELECT records based upon ASP.NET Roles
    ... security principals directly. ... be able to use SQL row-level security as well (which is something I've never ... When using Windows ... authentication in IIS, this will be a WindowsPrincipal object, but it would ...
    (microsoft.public.dotnet.security)
  • Re: How to SELECT records based upon ASP.NET Roles
    ... security principals directly. ... also be able to use SQL row-level security as well (which is something ... using Windows authentication in IIS, ...
    (microsoft.public.dotnet.security)
  • Re: Windows NT Security
    ... The easiest way is not to do the check from within SQL server back to Windows, ... and grant these permissions on the appropriate stored procedures. ... with the correct/same security permissions - and see if they error. ...
    (microsoft.public.sqlserver.programming)
  • Re: Logon with disabled admin account possible!
    ... disable the built in administrator account. ... But what we have in the customer domain with mixed Windows 2000 and Windows ... that any security related event is protocolled in the security event log of ...
    (microsoft.public.windows.server.security)
  • Re: Application password
    ... That is correct -- and with SQL logins, there is no way to enforce ... lock down Windows). ... There biggest effort so far is replacing the sa login ... >hold of that single password there entirely security scheme is broken. ...
    (microsoft.public.sqlserver.security)