How Do I Secure My Data?

  • Josef Finsel

Abstract

Maybe you won’t have security problems on that scale, but security is an issue that everyone needs to deal with in today’s interconnected world. Security in SQL Server has never been a glamorous subject. In fact, before SQL Server 2000, it was a running joke at demonstrations that logging into SQL Server as sa (System Administrator) with no password was Microsoft’s “standard” security model. The sad truth of the matter is, however, that many SQL Server sites run with no password on the sa account and allow all data access through the sa account. This practice of not placing a password on the sa account was caused by a combination of developers not understanding how the security model worked and the fact that SQL Server installed with a default of no password on the sa account. It’s also because too many books, articles, and documentation use this “security” strategy—or lack thereof.

Keywords

Security Model Enterprise Manager Execution Plan Individual Column Server Role 
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

Copyright information

© Josef Finsel 2001

Authors and Affiliations

  • Josef Finsel

There are no affiliations available

Personalised recommendations