What are Securables in SQL Server?

What is SQL Securables?

Securables are the resources to which the SQL Server Database Engine authorization system regulates access. For example, a table is a securable. Some securables can be contained within others, creating nested hierarchies called "scopes" that can themselves be secured.

What can Db_datawriter do?

Members of the db_datawriter fixed database role can add, delete, or change data in all user tables. Members of the db_datareader fixed database role can read all data from all user tables and views.

What is select all user Securables?

Basically “SELECT ALL USERS SECURABLES” permission is designed, when granted, to allow a user to view data in all databases he can connect. For auditing purposes, the new permission is very interesting and it can be also used to prevent someone to read.

What is Db_datareader role?

db_datareader: This role gives an ability to read the data from any table of the database. db_datawriter: This role gives an ability to write the data in the table of the database. When we grant this role to the user, it can insert the data, but it cannot read, change, or delete it.