Scripts SQL Divers

SCRIPT SELECTIONNE :

N2 Script - Create ADMIN account.sql


-- Creation du compte ADMIN Fols via SSMS
-- 1 Seule variable a modifier : CODE HOTEL sans le H (XXXX en rouge)

declare @p20 int set @p20=1000000024 exec up_User_CreateNewUserHotel
@Hote_Id_IN=XXXX,@User_Init_IN=N'SF3',
@InHotel_IN=1,@Uspf_Id_IN=1,@Arpf_Id_IN=6,@User_Name_IN=N'FOLS',
@User_Firstname_IN=N'Support N3',@User_Own_IN=N'SF',@User_Login_IN=N'admin',
@User_Date_Obs_IN=NULL,@User_Technical_IN=0,@User_Pwd_Encrypted_IN=1,
@User_Pwd_Never_Exp_IN=1,@User_Pwd_Update_IN=1,@User_Pwd_MustUpdate_IN=0,
@User_Pwd256_IN=N'4f75eaf9c221e388aea837802faeb8d4d33f605557bf8749f9121ccce29403356c358ec709d5c2cff61e3d32fd972d1afb410dde1558612cc23de7260e03acba',
@User_Pwd_Salt_IN=N'admin',@Usrc_Certif_Id_IN=-1,@New_User_Id_OUT=@p20 output select @p20