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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to Change the Owner of a Table back to dbo

Status
Not open for further replies.

DougP

MIS
Dec 13, 1999
5,985
0
36
US
How to Change the Owner of a Table back to dbo?<br><br>I changed it inadvertantly somehow and now the WEB site does not work anymore.<br> <p>DougP<br><a href=mailto: dposton@universal1.com> dposton@universal1.com</a><br><a href= > </a><br> Ask me how Bar-codes can help you be more productive.
 
I believe the easiest/safest way is to export the table and then import it with FROMUSER=current_user and TOUSER=DBO.
 
Thanks<br>I just remembered, that the ISP created it, so dbo is them.<br>I am a user on the database and when I create a table it is my user name (Universal1) and not dbo.<br><br>So I guess they will have to do it there.<br><br>Thanks again <p>DougP<br><a href=mailto: dposton@universal1.com> dposton@universal1.com</a><br><a href= > </a><br> Ask me how Bar-codes can help you be more productive.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top