Monday, July 13, 2020
Beetle Blog
How to change the owner of a database object
By: douglas - Sql Server - 4/26/2005 2:07:56 AM
To change the owner of an SQL database object (for example a table or stored procedure) this sql procedure can be used:
sp_changeobjectowner '<current owner>.<object name>','<new owner>'
  • current owner = the current owner of the object
  • object name = the object's name (could be the table's name or stored procedure's name)
  • new owner = the database user that should be the new owner of the object

sp_changeobjectowner is a built in SQL server object.

Last Modified: 4/26/2005 2:10:03 AM

Beetle Blog v0.2.2

Copyright © 1997 - 2020 All rights reserved.