dbd_listdb

exec master..dbd_listdb

This function lists the encrypted database names, their access status and encryption options.

Example output:

list encrypted databases

Name. The name of the encrypted database if it is online. If a database is offline, it is not listed here. If a database has grown beyond the license limit, it is not attached and not listed here.

Access. Column "Access" shows if the caller (current connection) has access to the database. The database Goldmine is encrypted with schema protection, and the caller isn't in dedicated logins, not using the dedicated application, didn't unlock the database with the password explicitly. So, access is currently denied for the caller.

The database "testdb" was encrypted with Maximum transparency mode, without schema protection or masking. DbDefence allows access to the database "testdb" if the user has appropriate SQL Server permissions.

FIPS 140-2 Encryption Mode. Both databases use FIPS 140-2 certified encryption module. Using this kind of encryption is often a requirement for governmental agencies.

Algorithm: AES-128 or AES-256 are commonly used encryption algorithms. DBDefence has the validation received from NIST - US and Canada standardization institute. See the validation.