Browse by Tags

All Tags » SQL Server - se... » basic SQL Server security concepts   (RSS)
Basic SQL Server Security concepts: ownership, CONTROL, TAKE OWNERSHIP
I realized today that while I have discussed earlier object permissions , I have not gone into the details of object ownership. I want to cover the following here: ownership of objects, how it can be changed, and the relatively new permission CONTROL Read More...
Posted 11 August 09 03:39 by lcris | 0 Comments   
Filed under , , ,
Basic SQL Server Security concepts: SIDs, orphaned users, and loginless users
I am grouping here two topics (orphaned users and loginless users) that are actually very different, but I have often seen confusion between them, so I am covering them together in an attempt to dispel that confusion. In a previous discussion of logins Read More...
Posted 25 October 07 05:42 by lcris | 0 Comments   
Filed under , , ,
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 , , ,
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 , , ,
Basic SQL Server Security concepts - logins, users, and principals
In this post I'd like to talk about some basic SQL Server security concepts. SQL Server has a less common design that can confuse users familiar with the security features of other software products, such as Microsoft Windows OS; in particular, the difference Read More...
Posted 23 March 07 10:25 by lcris | 2 Comments   
Filed under , ,

Search

This Blog

These posts are provided "AS IS" with no warranties, and confer no rights.

Syndication

Page view tracker