Security

SQL Server security: Database roles

Database roles for SQL servers can increase the security of your enterprise. Understand how to set up database roles, and learn how they function.

Discuss content posted by free mascot

Discussions about content posted by free mascot

Discuss content posted by Bryan Bitzer

Discussions about content posted by Bryan Bitzer

Extending the REVERT statement using the WITH COOKIE clause in SQL Server 2005

In a previous tip on Switching Execution Context using the REVERT clause, you have seen how to switch execution context to a more privileged user and revert back to the original context of the caller within a programmable object. The REVERT clause accepts a parameter WITH COOKIE to provide an even more granular option. How do we use it?

Configuring Anonymous Dialog Security in SQL Server 2005 Express Service Broker Conversation

Recent installments of our series have discussed configuring Service Broker full dialog level security, which required a mechanism to facilitate the exchange of certificates between communication partners. In this article, we will present an alternative approach, which eliminates this requirement by relying on anonymous dialog security.

Little Security Issues

There's a trend for smaller laptops called netbooks to make traveling with computers easier. However these devices may result in more security issues. Steve Jones comments on some of the problems.

Little Security Issues

There's a trend for smaller laptops called netbooks to make traveling with computers easier. However these devices may result in more security issues. Steve Jones comments on some of the problems.

Little Security Issues

There's a trend for smaller laptops called netbooks to make traveling with computers easier. However these devices may result in more security issues. Steve Jones comments on some of the problems.

Little Security Issues

There's a trend for smaller laptops called netbooks to make traveling with computers easier. However these devices may result in more security issues. Steve Jones comments on some of the problems.