Changing database object ownership

A system security officer or database owner can transfer the ownership of database objects using the alter... modify owner command.

The command lets a database administrator manage the assignment of objects due to employee changes or to separate the creation ownership of database objects. For example, a key custodian can create an encryption key and then transfer the ownership of the encryption key to another user.