Category: Security

• The TRUSTWORTHY Database Property Explained – Part 2

  

  2013-06-18 - General, Security, Trustworthy

  Why is the TRUSTWORTHY db option so dangerous? This second post on that topic shows how that “trust” can be misused to elevate a login to be a sysadmin.

  [more…]

• The TRUSTWORTHY Database Property Explained – Part 1

  

  2013-02-19 - General, Security, Trustworthy

  Do you know what the TRUSTWORTHY database property does to your stored procedure security? Read on to learn more about the behavior of this commonly misunderstood database property.

  [more…]

• Decrypting Encrypted Database Objects

  

  2013-01-08 - Cryptography, General, SQL Server Internals

  Did you ever have to fix something in an encrypted stored procedure but did not have access to the original anymore? This article shows how to decrypt encrypted SQL Server object using a simple method called Known Plaintext Attack.

  [more…]