From the course: Securing SQL Server 2012

Unlock this course with a free trial

Join today to access over 22,400 courses taught by industry experts.

SQL Server securables

SQL Server securables

Microsoft defines securables in SQL Server, as the resources to which the SQL Server Database Engine authorization system regulates access. Essentially these are the database objects to which you can apply security on your instance of SQL Server some securables are standalone and others may be contained within another securable. Starting at the highest level, SQL Server supports hierarchies of securables, that is securables that are nested with inside the scope of another securable. SQL Server provides three scopes at the highest level. The server securable, the database securable and the schema. The server can be considered the instance of SQL Server. Where as the database is the specific database hosted on the instance and schemas are security domains or containers that are used to store database objects. Lets take a look at the server scope. On SQL Server management studio, under object explorer, if we expand the server objects folder, we can see some of the server objects that…

Contents