Re: VB.NET and SQL Security

You can use DPAPI in your VB.NET code to access SQL Server 2000 so you can
encrypt the data that is going to and from your SQL Server
http://www.obviex.com/samples/dpapi.aspx



"bam" <bam@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:32873683-405E-4AF2-897B-1F7AE9703ECC@xxxxxxxxxxxxxxxx
Hello All, we are looking at the security options that we have available
to
us and we are trying to generate some different ideas on how people are
handling this. We want to know how people are designating security based
on
different types of scenario's... We have one that needs to have user "a"
get
a different form but user "a" can change and user "b" needs a different
form
and user "b" can change as well. We would like to do this where it
captures
the "Network Logon" and then compares that to a table in the database or
maybe a centralized table in an all security database or something (with
some
type of structure) that we can use for all the apps.. Not sure what the
best
case is just looking for ideas / websites where people have these types of
things happening


.

Relevant Pages

  • Re: SQL Server 2000 / 2005 Encryption
    ... to encrypt your SSL connections will be different. ... SQL Server can generate its own self-signed certificates though, and that should make the SSL encryption/connectivity easier for you. ... Excel does not know how to decrypt data stored in SQL Server 2005 in encrypted form. ...
    (microsoft.public.sqlserver.security)
  • Re: Storing Connection String
    ... you can encrypt the traffic to the SQL Server. ... Hitchhiker's Guide to Visual Studio and SQL Server ... My idea is to have just one database user whose username and password ... Which means that if an user get hold of connection string ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Securing an MDF file
    ... Windows 2000 support encrypted file system property. ... Below are the steps encrypt the data files: ... Logon with the SQL Server startup account ... database files are encrypted under the identity of the account ...
    (microsoft.public.sqlserver.server)
  • Re: securing mdf files
    ... You can use the Encrypted File System Support on Windows 2000. ... Below are the steps encrypt the data files: ... Logon with the SQL Server startup account ... database files are encrypted under the identity of the account ...
    (microsoft.public.sqlserver.security)
  • Re: Encription for MDF files
    ... EFS by itself is not a complete solution. ... If the box is stolen - including the EFS recovery keys, ... then encrypt it before it is stored and decrypt it when retrieving. ... > 1) Logon with the SQL Server startup account ...
    (microsoft.public.sqlserver.security)