Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Principals, Securables, Permissions oh my. SQL 2008/2005 Expand / Collapse
Author
Message
Posted Monday, August 31, 2009 9:48 PM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Wednesday, March 12, 2014 8:35 AM
Points: 1,136, Visits: 689
Comments posted to this topic are about the item Principals, Securables, Permissions oh my. SQL 2008/2005
Post #780421
Posted Monday, August 31, 2009 10:40 PM
UDP Broadcaster

UDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP Broadcaster

Group: General Forum Members
Last Login: Wednesday, March 26, 2014 9:50 AM
Points: 1,458, Visits: 2,435
Gud question. I was bit confused between Principals and Securables.




Post #780433
Posted Tuesday, September 01, 2009 4:29 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, September 02, 2009 12:04 AM
Points: 1, Visits: 1
yeah..i too got confused with principals and securables
Post #780553
Posted Tuesday, September 01, 2009 10:14 AM


Keeper of the Duck

Keeper of the Duck

Group: Moderators
Last Login: Thursday, April 03, 2014 10:06 PM
Points: 6,621, Visits: 1,851
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, CISA, MCSE, Security+, MVP - SQL Server
Regular Columnist (Security), SQLServerCentral.com
Author of Introduction to SQL Server: Basic Skills for Any SQL Server User
| Professional Development blog | Technical Blog | LinkedIn | Twitter
Post #780864
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse