What algorithm is used to encrypt the Database...

Which protocols support Kerberos authentication on SQL Server...

Ownership Chaining

Security in SQL Server is not too complex, following a fairly simple framework for allowing and preventing access to data. However there are a few places where it can get tricky and some concepts that many people do not understand. Rob Farley brings us an explanation of one of those areas: ownership chaining. Read about how ownership chaining can be useful and also how it may open security holes in your environment.

Ownership chaining in SQL Server 2005

Ownership chains have unique permissions' issues in SQL Server 2005. Contributor Serdar Yegulalp explains the access levels of ownership chains, and the benefits of "EXECUTE AS."

When you install SQL Server 2005 and create...

You have just upgraded your SQL Server 2000...

Improving Data Security by Using SQL Server 2005

Microsoft IT developed strategies to reduce the duplication of sensitive data and improve the security of personally identifiable information in the Microsoft IT LOB application space. These strategies are based on the new security features and functionalities that Microsoft® SQL Server™ 2005 includes.

How many credentials can one login be mapped...

John has determined some of the server administrators...

Credentials in SQL Server 2005 are used to...