Microsoft® SQL Server 2012 Unleashed

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 ...