From the course: Microsoft Azure Database Administrator Associate (DP-300) Cert Prep by Microsoft Press

Unlock this course with a free trial

Join today to access over 24,900 courses taught by industry experts.

Configure database and object-level permissions using graphical tools

Configure database and object-level permissions using graphical tools

From the course: Microsoft Azure Database Administrator Associate (DP-300) Cert Prep by Microsoft Press

Start my 1-month free trial Buy for my team

Configure database and object-level permissions using graphical tools

“

- Welcome back. This is lesson 4.4, configured database and object level permissions using graphical tools. Before we discuss permissions, you'll often hear the word securable come up when talking about permissions. A securable is a resource. So for example, a table. So when you hear about granting permissions to a securable, what it's referring to is what can be done with that securable, what permissions you can add to that securable. And there's several levels of permissions. There's, for example, basic permissions such as a delete insert, select update. These are actions that the user can take on the securable. Select, for example, allows the user to view the data. Insert, allows the user to add data, for example. Then there are additional permission such as alter control, reference, take ownership, review definition. So for example, view definition allows the principle to view the definition of the securable, like the table, take ownership allows the principle to assume ownership…

Contents