Join Adam Wilbert for an in-depth discussion in this video Understanding ownership chains, part of Database Fundamentals: Administration.
- View Offline
- When working with data stored in SQL Server, it's often…that a user isn't directly accessing the data tables.…They'll use a stored procedure or run a report…that pulls in a view which will in turn…fetch the data from a data table.…When this happens, SQL Server relies on something called…ownership chains in order to make sure…that the database isn't exposing sensitive data…to unauthorized users.…Ownership chains apply to views,…stored procedures, and user defined functions.…Let's take a look at how they work…by exploring the Invoices Totals view…inside of the H+ Active database.…We can find it by expanding the views table here,…and it says View right there.…
Let's right click on it, and open it up…in the Design view.…We can see that the invoices Totals view…pulls in information from five different tables…inside of the H+ Active database.…Let's go ahead and close this down,…and if we right click on it and choose Select Top 1000 Rows,…we can see that the data is being processed…into these four different columns here.…
Note: This course will also prepare certification candidates for the "Administer a database" domain of the Microsoft Technology Associate (MTA) Exam 98-364, Database Administration Fundamentals.
- Securing the database server
- Understanding Windows authentication vs. SQL Server authentication
- Assigning fixed server roles and fixed database roles
- Granting object-level permissions
- Understanding ownership claims
- Creating backups
- Restoring a database