From the course: Designing Database Solutions for SQL Server 2016

Unlock the full course today

Join today to access over 23,300 courses taught by industry experts.

Object owner permissions

Object owner permissions - SQL Server Tutorial

From the course: Designing Database Solutions for SQL Server 2016

Start my 1-month free trial Buy for my team

Object owner permissions

“

- [Instructor] Every object in a SQL Server database has an owner and those owners maintain full administrative control over the objects. Permissions to alter, select, drop and otherwise modify the object cannot be revoked, even by the database administrator. By assigning ownership to a schema you can control all of the objects within the schema at once. A schema can only be owned by a single user, but ownership can be transferred as needed when a user's area of responsibility changes without affecting all of the objects that belong to the schema. Lets take a look by creating a new database and I'll call it OwnershipDB. Then, inside of this database we'll create a schema called Inventory with the authorization dbo which is my current user account. Next, inside of the Inventory schema, we're going to create a table called Products and it's going to have a product ID and a product name. And then if I scroll down a little bit, we'll see that we're also going to insert some values into…

Contents