How Do I Secure My Data?
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.
KeywordsSecurity Model Enterprise Manager Execution Plan Individual Column Server Role
Unable to display preview. Download preview PDF.