Post reply

user database owner

  • March 24, 2008 at 8:54 pm

    #185471

    I am new to MS SQL Server 2005. When creating a new database, does it matter who the owner would be (i.e. administrator or a created local user)? Is there a security issue if you use the administrator as the database owner? What is the best practice?

    Thanks in advance!

    Mama Iriw

  • March 24, 2008 at 9:07 pm

    #793309

    I 've never worried about the owner, though in production I've tried to keep it to SA for consistency and to be sure there are no issues.

  • March 24, 2008 at 9:14 pm

    #793312

    Thanks!

  • March 25, 2008 at 10:07 pm

    #793848

    I always add SA as well. I have never really had to worry either, but we have had a turn over in DBA's who created databases with their user ids and then we end up with a ton of owners because the user id is no longer valid, so I think it is more as a best practice to use SA.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply