Laurentiu Cristofor's blog @microsoft.com : September 2007

Security and copy protection: I have been watching the SQL Server Security forum for several years now and there is one question that gets spawned about once a month under different titles. It invariably begins with a request for guidance on how to secure access to a database, which Read More...
Posted 24 September 07 03:57 by lcris | 0 Comments
Filed under SQL Server - security, SQL Server, computer security
Basic SQL Server Security concepts - ownership chaining: good and evil; schemas: At some point during SQL Server's history, its designers must have confronted the following problem: how to give someone permission to see parts of a table without giving him any permission on the table? Slices of a table are easily defined using views, Read More...
Posted 13 September 07 11:37 by lcris | 0 Comments
Filed under SQL Server - security, SQL Server, computer security, basic SQL Server security concepts
Basic SQL Server Security concepts - permissions and special principals: sa, dbo, guest: In a previous post , I talked about the various types of principals in SQL Server. Let's have a further look in this post at permissions and at some of the hardcoded principals that ship with any installation of SQL Server. Permissions are what allow Read More...
Posted 12 September 07 03:12 by lcris | 0 Comments
Filed under SQL Server - security, SQL Server, computer security, basic SQL Server security concepts

Laurentiu Cristofor's blog @microsoft.com