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: Monday, October 20, 2014 6:48 PM
Points: 1,136, Visits: 699
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
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: 2 days ago @ 11:41 PM
Points: 1,563, Visits: 2,615
Gud question. I was bit confused between Principals and Securables.




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

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

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


Keeper of the Duck

Keeper of the Duck

Group: Moderators
Last Login: Yesterday @ 7:50 AM
Points: 6,624, Visits: 1,874
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