change user data base owner to db_owner role code example Example: To change the database owner in SQL server Use OnlineRestaurant exec sp_changedbowner 'sa'