Protection Level

Please read the following carefully; it may save your time!

Maximum protection

The key feature of DbDefence, what makes it unique among other encryption tools is that it can protect schema and data from DBA. With this feature (enabled by default) the database becomes protected from all kinds of applications. No matter if it is a web service, replication or server admin with SQL Server Management Studio. You must take additional steps to allow access to your database. These steps may include:

  • Allowing certain SQL logins to access database transparently. More
  • Allowing certain applications to access database transparently. More
  • Programmatically add unlocking SQL statements to your application. More

Only Encryption

In many cases there are only formal requirements to data protection. The easiest in this case would be to encrypt database files, but apply no additional access restriction. In this case application can use the database immediately after encryption. Take a look how to enable this mode.