Principals, Securables, Permissions oh my. SQL 2008/2005

  • Bob Griffin

    SSCertifiable

    Points: 5982

    Comments posted to this topic are about the item Principals, Securables, Permissions oh my. SQL 2008/2005

  • Joy Smith San

    SSC-Insane

    Points: 24877

    Gud question. I was bit confused between Principals and Securables.

  • xxxxxxx

    SSC Rookie

    Points: 41

    yeah..i too got confused with principals and securables 😀

  • K. Brian Kelley

    SSC Guru

    Points: 114486

    This may be a semantic argument, but just for clarification...

    In SQL Server, scope refers to a securable that contains others securables. Server, Database, and Schema are all scopes. So the database scope contains all of these. I'm not sure it's appropriate to say all of these are examples with database scope. That'd be like when a baseball is in a glove saying that the baseball is an example with glove scope.

    K. Brian Kelley
    @kbriankelley

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply