SQL Server 2005 Distilled

Chapter 2. What Everyone Should Know About Security

Those who seek to illicitly enter a database will take advantage of any vulnerability. Over the last decade, the evolution of database technology has been focused on abilities—from scalability to reliability. Now in the age of cyberterrorism, security is the most important capability for a database. Additionally, the security of the SQL Server infrastructure is the single most important task for database administrators. Although typical application deployments present a number of obstacles for malicious wrongdoers, including firewalls, passwords, user control, and monitoring, the fact remains that the database itself is the last line of defense. The SQL Server Security architecture has been ...