What is the database owner? The database owner is a user that has permissions to perform all activities in a database. On a SQL server, database owners can be changed. Any user that has all the rights to connect to the SQL server can become the owner of any database. In this article I will give you a step by step guide on How to Change Database Owner with SQL Server Management Studio
1. Connect to your database using Microsoft SQL Server Management Studio.
2. In the object explorer, right click on the database that you want to change the owner and go to “Properties” menu:
3. In the properties window, go to menu “Select a page -> Files”. Search or write the new owner. For the purposes of this example I will set “WspSqlAdmin” as an owner. Once you’re done, click on OK to save your changes:
4. And that’s it! The owner has been changed!
This concludes Change Database Owner with SQL Server Management Studio