/* sp_help_revlogin script
** Generated juin 16 2014 11:40AM on BENSRV49 */
-- Login: BUILTIN\Administrateurs
CREATE LOGIN [BUILTIN\Administrateurs] FROM WINDOWS WITH DEFAULT_DATABASE = [master]
-- Login: AUTORITE NT\Système
CREATE LOGIN [AUTORITE NT\Système] FROM WINDOWS WITH DEFAULT_DATABASE = [master]
-- Login: BENSRV49\SQLServer2005MSSQLUser$BENSRV49$MSSQLSERVER
CREATE LOGIN [BENSRV49\SQLServer2005MSSQLUser$BENSRV49$MSSQLSERVER] FROM WINDOWS WITH DEFAULT_DATABASE = [master]
-- Login: BENSRV49\SQLServer2005SQLAgentUser$BENSRV49$MSSQLSERVER
CREATE LOGIN [BENSRV49\SQLServer2005SQLAgentUser$BENSRV49$MSSQLSERVER] FROM WINDOWS WITH DEFAULT_DATABASE = [master]
-- Login: BENSRV49\SQLServer2005MSFTEUser$BENSRV49$MSSQLSERVER
CREATE LOGIN [BENSRV49\SQLServer2005MSFTEUser$BENSRV49$MSSQLSERVER] FROM WINDOWS WITH DEFAULT_DATABASE = [master]
-- Login: ADSLOCAL\G550125
CREATE LOGIN [ADSLOCAL\G550125] FROM WINDOWS WITH DEFAULT_DATABASE = [Provisionning]
-- Login: BYO_Intranet
CREATE LOGIN [BYO_Intranet] WITH PASSWORD = 0x010040F9933C11AECF2516E54529C9EE06DA7A30D5D87B30AFF3 HASHED, SID = 0xBD2C8B3C29528D469DB3E9873DAD3745, DEFAULT_DATABASE = [master], CHECK_POLICY = OFF, CHECK_EXPIRATION = OFF
-- Login: Prov
CREATE LOGIN [Prov] WITH PASSWORD = 0x01000228015B814F17F935E724E0A8216846105C06B4C08B15F1 HASHED, SID = 0xD896DBE289524D4CAD5ECA0D6986A452, DEFAULT_DATABASE = [master], CHECK_POLICY = OFF, CHECK_EXPIRATION = OFF
-- Login: chbr
CREATE LOGIN [chbr] WITH PASSWORD = 0x0100D76FA003B2BCF2A7E90D3D8EA55EF3055F275C26325A3C2F HASHED, SID = 0xCAE61BE09F07C5439E60322545A324A3, DEFAULT_DATABASE = [master], CHECK_POLICY = OFF, CHECK_EXPIRATION = OFF
-- Login: ADSLOCAL\G542777
CREATE LOGIN [ADSLOCAL\G542777] FROM WINDOWS WITH DEFAULT_DATABASE = [master]
-- Login: ADSLOCAL\G546860
CREATE LOGIN [ADSLOCAL\G546860] FROM WINDOWS WITH DEFAULT_DATABASE = [master]; REVOKE CONNECT SQL TO [ADSLOCAL\G546860]
-- Login: ADSLOCAL\g554876
CREATE LOGIN [ADSLOCAL\g554876] FROM WINDOWS WITH DEFAULT_DATABASE = [master]
-- Login: stc_intranet
CREATE LOGIN [stc_intranet] WITH PASSWORD = 0x010023250A12D6468BFA5FCD55CDECC904F0C500522F0D6DD03F HASHED, SID = 0x5AA53518BEA4384383EBDCBEE545B6A4, DEFAULT_DATABASE = [master], CHECK_POLICY = OFF, CHECK_EXPIRATION = OFF
-- Login: ADSLOCAL\G550043
CREATE LOGIN [ADSLOCAL\G550043] FROM WINDOWS WITH DEFAULT_DATABASE = [master]
Partager