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 Mike Lewis 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 login name for user dbo

Status
Not open for further replies.

Ovatvvon

Programmer
Feb 1, 2001
1,514
US
We have a database where the default user account, dbo, has a login name of "abc". We actually want to have "abc" be its own login name with read/write permissions only.

Is there a script somewhere that can change the login name for dbo back to the default, so we can separate "abc" to its own login?

-Ovatvvon :-Q
 
nevermind, I found it: sp_changedbowner 'sa'

Thanks anyway though! :)


-Ovatvvon :-Q
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top