FAQ: change object owner


	About Us
	SSWUG Articles
	Articles
	FAQ

	Administration
	Backup/Restore
	Connectivity
	Development
	General
	Installation
	OLAP
	Replication
	Transfer/move
	Trouble
	SQL 6.5

	Scripts
	Tips
	Test Exams
	Advertise
	Download
	History
	Search
	Traffic
	Related Links


Add to Favorites

How can I change the object owner?

Answer:

You can use the sp_changeobjectowner system stored procedure to change the object owner.
Read about the sp_changeobjectowner stored procedure in SQL Server Books Online.
This is the example to change the owner of the authors table in the pubs database to John:

USE pubs
GO
EXEC sp_changeobjectowner 'authors', 'John'
GO

See also this link:
How can I change the database owner?

Visit The SQL Server Worldwide User's Group for all the latest news and information about SQL Server, Oracle, DB2 and XML for developers and administrators.

(c) 1997, 2005 Bits on the Wire, Inc