SQL impact when dropping Windows users that created dbs, SSIS...

• Greg J

  SSCarpal Tunnel

  Points: 4288

  More actions

  January 9, 2009 at 7:30 am

  #204851

  Not sure if I understand the security implications of dropping a Windows user on a SQL server running in mixed mode.

  A Windows user has developed both SSIS packages and DB's on a particular box. It's a managed environment, and the Windows user is going to be dropped tomorrow morning.

  The database is showing that it's "owner" is the Windows user that will be dropped. What happens by default to this database property, and what should I do preemptively to reduce the impact?

  Thanks

• MarkusB

  SSC-Dedicated

  Points: 37370

  More actions

  January 14, 2009 at 3:19 am

  #926443

  For the database it's best to change the owner using sp_change_dbowner.

  Removing the login will not have any immediated impact but g.e. running sp_help will fail if the the owner login does not exists.

  For the SSIS packages I don't think it makes any difference, but I maybe wrong.

  [font="Verdana"]Markus Bohse[/font]