Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to make table owner other than "dbo"?

Status
Not open for further replies.

sjh

Programmer
Oct 29, 2001
263
US
Hi,

What are the necessary steps to create new tables and have the table owners as a user other than "dbo"? For example, "myuser". Should I delete the "dbo" user account in my database? (I am using Windows authentication.)


Also let me know if this is not an accepted procedure in the 'real-world' setting.

Thanks for your help!

 
dbo is Database Owner. You don't want to delete that.

Do you really want to change the owner of a TABLE or the owner of the DATABASE?

If you want to change the owner of an object (table, etc) use the sp_changeobjectowner command. If you want to change the owner of the database, use sp_changedbowner command.

Refer to the BOL for more information on both commands.

BTW-you didn't say which SQL Server version you are using...these commands are for SQL Server 2000, I don't know if they exist in version 7.

-SQLBill

BOL=Books OnLine=Microsoft SQL Server's HELP
Installed as part of the Client Tools
Found at Start>Programs>Microsoft SQL Server>Books OnLine

Posting advice: FAQ481-4875
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top