Employee Lifecycle Management

System security officers or database owners can transfer the ownership of database objects using alter... modify owner.

The command provides a way for a database administrator to manage the assignment of objects due to employee changes or to separate the creation ownership of database objects.