November 7, 2002 at 12:47 pm
Is there anything wrong with having all DBO's set to SA? By default DBO gets assigned to the user creating the database. Users come and go, normally SA never leave, never sleeps, and always works. Is there way to change the default DBO user to SA? I know I can manually change it later user sp_changedbowner!
Gregory Larsen, DBA
If you looking for SQL Server Examples check out my website at http://www.geocities.com/sqlserverexamples
Gregory A. Larsen, MVP
November 7, 2002 at 1:12 pm
I don't think there is a way to have it default. SA would have to create the database for it to default as dbo.
November 7, 2002 at 2:19 pm
I make it a habit to use the sa account to create databases for that very reason, and have never encountered any issues from it. Like antares686 though, I don't believe there is a way to do it once the database is created. If you find out different, I'd be interested in how it was done as well.
November 7, 2002 at 2:29 pm
I have come across this and did some research on it.even if you have the permissions of a DBO and not an SA user it creates the objects as if you are creating them but not DBO.
November 7, 2002 at 2:46 pm
Scorpion_66: If the database was originally created by a user other than SA you can issue the command:
exec sp_changedbowner 'SA'
To change the owner to 'SA'
Gregory Larsen, DBA
If you looking for SQL Server Examples check out my website at http://www.geocities.com/sqlserverexamples
Gregory A. Larsen, MVP
November 7, 2002 at 2:56 pm
I know that, greg, I was talking about what you asked, sa defaulting to dbo, but thanks, I wasn't very clear...
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply