Logins and users

• Austin_123

  SSCommitted

  Points: 1648

  More actions

  June 12, 2008 at 7:10 am

  #125817

  Hi All,

  I want to generate scripts for users and their associated permissions on the xyz database and at the same time I want to generate script for associated logins and their roles over the xyz database.

  I am using SQL 2005 environment.

  Needs urgent help.

  Regards,

  Austin

• Greg Charles

  SSC-Forever

  Points: 45403

  More actions

  June 12, 2008 at 9:41 am

  #827962

  Lots of scripts listed here: http://www.sqlservercentral.com/Scripts/Security/. Take your pick. I've used versions of several of them.

  Greg