Managing Securables
Securables are the entities in SQL Server on which permissions can be granted. In other words, principals (for example, users or logins) obtain permission to securables. This chapter describes many examples of securables, including tables, databases, and many entities that have been part of the SQL Server security model in past versions. SQL Server 2012’s security model contains a granular set of securables for applying permissions.
Securables are hierarchical in nature and are broken down into nested hierarchies of named scopes. Three scopes are defined: at the server, database, and schema levels. Table 17.4 lists the securables for each scope.
TABLE 17.4 SQL Server 2012 Securables
As mentioned earlier, a hierarchy exists ...
Get Microsoft® SQL Server 2012 Unleashed now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
