SQL Server Performance Forum – Threads Archive

object owner

is it a good technical idea to have all object owner as DBO.?

Yes it is, because is easy to manteinance and for security razons.
Luis Martin
Moderator
SQL-Server-Performance.com

why easier to maintain and what security reasons?

If all objects owner are DBO, only Administrator can manipulate those objects.
Some sp to help maitenance, only use objects belong to DBO and no to others.
I don’t remember right now those sp.
Luis Martin
Moderator
SQL-Server-Performance.com

http://support.microsoft.com/default.aspx?kbid=275312 for information on changing object owner or normally you can use sp_changeobjectowner which is system supplied. Refer to this articlehttp://www.winnetmag.com/Article/ArticleID/41773/Windows_41773.html by Kalen Delaney about object ownership and security. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

]]>