Post reply

Creating a database

  • January 6, 2011 at 4:48 am

    #388568

    Hi, I am creating a new database and wanted to know what is the best user account to use for this. Should i use my own account, i have all permissions. Or is it best practice to setup a specific account for that database.

    Just a little query also, there is an old db on a 2000k server and in the owners properties is an asterisk *. Why is this the case?

    Thanks in advance.

  • January 6, 2011 at 6:21 am

    #1270039

    In the first question I assume is about which account to set as Database Owner. You can set any account or "sa" as DBO.

    For the second question, do you see the owner details or it is NULL, when you execute sp_helpdb 'databasename'?

    Pradeep Adiga
    Blog: sqldbadiaries.com
    Twitter: @pradeepadiga

  • January 6, 2011 at 8:20 am

    #1270125

    Thank you, you have answered my question with the 1st answer. I have found out that the 2nd query was an account created by the dev team and is ok to be used as an owner.

    Thanks for your input:-)

  • January 6, 2011 at 5:46 pm

    #1270374

    It is best practice to create a separate account to run the SQL server service. If you are just creating a new database in an instance then I always recommend entering 'SA' for the owner.

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

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