• Product Info
  • Features
  • Downloads
  • Order
  • Support
  • FAQ

  • What type of database objects can be encrypted using dbLockdown?
  • How does dbLockdown restore encrypted database objects?
  • Will database objects still function after they are encrypted?
  • Can encrypted database objects be decrypted?
  • What type of encryption does dbLockdown use?
  • What SQL Server security permissions are necessary to encrypt and restore database objects with dbLockdown?
  • Will SQL Server replication still function after replicated objects are encrypted?
  • What happens to encrypted database objects when a SQL Server database is upgraded?

    What type of database objects can be encrypted using dbLockdown?
    Stored procedures, triggers, views and user defined functions can be encrypted.

    How does dbLockdown restore encrypted database objects?
    When a database object is encrypted using dbLockdown a copy of the database object's original CREATE script is archived. When dbLockdown restore's an encrypted database object the existing database object is deleted and and re-created (without encryption) using the original CREATE script.

    Will database objects still function after they are encrypted?
    Yes, encrypting a database object does not in any way compromise its functionality. An encrypted database object's script cannot be viewed without dbLockdown. Please note that an encrypted database object will not be published as part of SQL Server replication.

    Can encrypted database objects be decrypted?
    There is no functionality within dbLockdown or SQL Server 2000 to decrypt encrypted database objects. If you encrypt a database object using dbLockdown a copy of the original database object script is archived, allowing dbLockdown to restore the database object.

    What type of encryption does dbLockdown use?
    dbLockdown uses SQL Server 2000's built-in encryption. Database objects such as stored procedures, triggers, user defined functions and views are encrypted using the T-SQL encryption parameter ('WITH ENCRYPTION'). This encrypts a database object's script stored in the syscomments table. Once a database object has been encrypted it's script is indecipherable and cannot be decrypted. An ecrypted database object can only be restored from dbLockdown or from another valid copy.

    What SQL Server security permissions are necessary to encrypt and restore database objects with dbLockdown?
    The user specified in the SQL Server's registration properties must belong to the db_owner or db_ddladmin database roles.

    Will SQL Server replication still function after replicated objects are encrypted?
    No, SQL Server does not support the replication of encrypted database objects. This may generate an error - "#21004 Cannot publish the database object because it is encrypted".

    What happens to encrypted database objects when a SQL Server database is upgraded?
    During an upgrade, SQL Server uses the encrypted script stored in syscomments table to re-create encrypted database objects.

  • Home |  General |  Products |  Services |  Clients |  Downloads |  Support
    Copyright 2009 Ecatenate Limited