Re: How to i hide my database schema from...

From: Russell Fields (RussellFields_at_NoMailPlease.Com)
Date: 02/26/04


Date: Thu, 26 Feb 2004 16:17:14 -0500

w

Anyone who has access to the database has access to examine, but not
necessarily modify, the schema.

If you Google for encryption and SQL Server you should find a couple of
hits. I assume that you want the data encrypted in the database.

If you mean the files themselves, an alternative is to use NTFS encryption
on the files.

Russell Fields
"w" <wilcorning@hotmail.com> wrote in message
news:6a24cdf7.0402261134.be0b6ca@posting.google.com...
> everybody except 1 login which is non-sa in sql server 2000.
>
> Even sa should not be able to access the schema.
>
> Also are there anyways encrypt data in sql server 2000



Relevant Pages

  • Re: SQL or Access DB
    ... As far as encryption goes though... ... with Sql Server you can use SQL DMO and encrypt your stored procedures ... installation - Security was absolutely critical and in most instances, ... > then we create a nice gui around this database and sell it to automotive ...
    (microsoft.public.dotnet.languages.vb)
  • Re: Cryptography in SQL Server 2000
    ... A company is vulnerable when its security ... > database encryption solution with protected key-management software ... > tested by the SQL Server Test Lab. ...
    (microsoft.public.sqlserver.security)
  • Re: Encryption; SQL Server 2005 & Windows 2003 Server
    ... We *must* encrypt all data items in a Database. ... SQL Server 2005 Encryption places a tremendous burden on the ... Response timeare unbearable. ...
    (microsoft.public.sqlserver.security)
  • Re: Sybase to Access
    ... The Grand Master ... Have you used database encryption for SQL Server before? ... We're a fully supported platform for VB6 ADO code against SQL Server. ...
    (microsoft.public.dotnet.languages.vb)
  • Re: Newbie - Is this Reasonable?
    ... because this hash is stored in the database. ... So you use PKCS5v2 to generate a key hash from a salt and the user's passphrase, then store the salt and the hash in a database. ... are even more critical in database applications because the payoff from tampering with selected fields may be much higher, fields tend to be fixed-length so it's easier to tamper with them in a meaningful way, and databases lend themselves to off-line analysis, so the attacker can marshall more resources and take more time to attack your system. ... You're using a stream cipher for encryption. ...
    (sci.crypt)