Schemas

Bit of a clue as to the mystery in the previous post, but people who work with Oracle tend to have a pretty good idea what a database schema is for – I find SQL Server people are a bit less clear (I include myself in this – I think the problem is that we’re not quite sure which problem they solve).
Trying to write about SQL Server security I came up with the following definitions:

  1. A ‘Namespace’ (or a way of creating self-describing objects).
  2. A way of giving users a shorthand by which they can access an object (think: a Users’ default schema).
  3. A layer of abstraction with regard to database object ownership.
  4. A dynamic security boundary, or a container on which users can be granted or denied permissions.

I think 3 & 4 stand out as the most compelling – especially given that no. 3 solves a problem that used to cause real administrative headaches when it came to dropping users that owned objects.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: