george sibbald (5/14/2010)
Some third party apps require a particular ID be the dbo, so watch out for that.Having the db owned by an ID that restored it is not in itself a problem, worse that can happen is if the person leaves the company say and their ID is removed from AD (presuming windows authentication) then the owner becomes 'unknown'. the database will continue to function, sp_helpdb fails though, which can be a PITA.
Usual standard is to make all dbs have the same owner, usually SA. There is a security risk in this though, IIRC to do with cross database chaining, our resident security expert Brian Kelley is not a fan.
What security risk is their with using SA as the owner? I am not aware of any security issues - unless you have users accessing the system using the SA account (why?).
Not sure how cross database ownership chaining would be affected by the owner of the database.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs