Security Logins

• shekar Rao Lakavath

  Newbie

  Points: 4

  More actions

  January 29, 2009 at 9:46 pm

  #127144

  Is there any way where I can pull all the Database logins. I need this because we do databases Refreshes and we loss all the logins for the database which we do refresh.

• panwar.jt

  Default port

  Points: 1418

  More actions

  January 29, 2009 at 11:23 pm

  #935309

  use Sp_WHo

  if you are admin then

  can use

  sp_helplogins

  Cheers

  KD

• iainthepitman

  SSCommitted

  Points: 1666

  More actions

  January 30, 2009 at 2:11 am

  #935335

  for databases you could use

  select * from sys.database_principals