Post reply

Removing a database owner account

  • September 2, 2010 at 4:27 am

    #239807

    Hi,

    We are soon going to be shutting down our old windows domain and have found that some of our SQL databases have accounts on this domain as their owner. Will removing these accounts have any impact on these databases? If so, does the database ownership need to be changed on these before we shut down the domain and if so, does need it to be changed to 'sa'? These owner permissions are only on the databases themselves and not on any of the objects contained within them.

    Thanks,

    Andy

  • September 2, 2010 at 4:39 am

    #1215492

    Hi,

    Its better to change the owner of database and then drop the login account which is not required. Use sp_changedbowner stored proc to change the db owner of a database.

    Thanks,

    Amit Kulkarni

  • September 2, 2010 at 4:47 am

    #1215494

    Thanks Amit.

    I just want to check, does that only change the ownership on the database and none of the objects underneath and is it best practice to change to 'sa'?

    Also, can the command to change ownership be run any time or is it best to do when no users are logged in?

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

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