SQL Server will take the person's loginname as the owner while creating the database. Same loginname will remain there for years even after the person left the company.
The disabled/inactive user still owning the DataBase, SQL Server doesn't care whether the owner is active or not.
Best practice: Please create database with sa as owner for the first time or update it once you complete creating the object.
This is applicable for SQL Server Agent Jobs as well.
Refer my other post for scripts https://sqlserverrandoms.blogspot.com/2018/03/cleaning-up-orphan-users-and-finding.html
The disabled/inactive user still owning the DataBase, SQL Server doesn't care whether the owner is active or not.
Best practice: Please create database with sa as owner for the first time or update it once you complete creating the object.
This is applicable for SQL Server Agent Jobs as well.
Refer my other post for scripts https://sqlserverrandoms.blogspot.com/2018/03/cleaning-up-orphan-users-and-finding.html
No comments:
Post a Comment