/* THIS SCRIPT SHOULD BE EXECUTED BY AN ADMINISTRATIVE USER WITH A FULL UNDERSTANDING OF THE REAL MAGNET INTEGRATION. THIS SCRIPT IS INTENDED TO BE USED TO CREATE A LOGIN FOR REAL MAGNET'S UNIVERSAL WEB SERVICE INTEGRATION. THIS IS THE RECOMMENDED APPROACH TO CREATING THE LOGIN NEEDED FOR THE INTEGRATION. PLEASE UPDATE THE PASSWORD AND DEFAULT_DATABASE IN THE SCRIPT BELOW TO REFLECT WHAT IS NECESSARY FOR YOUR INSTALLATION */ /* /********************** Check if the login exists *******************************/ IF NOT EXISTS(Select * From master..syslogins Where name = 'RealMagnet') BEGIN /********************* Create the login if it does not exist *******************/ BEGIN TRAN LoginCreation CREATE LOGIN RealMagnet WITH PASSWORD = '[PLACEHOLDERPASSWORD]', DEFAULT_DATABASE = [PLACEHOLDERDATABASE] , DEFAULT_LANGUAGE = us_english; /********************* Create the user if it does not exist ********************/ CREATE USER RealMagnet FOR LOGIN RealMagnet; */ /*********************IF LOGIN ALREADY EXISTS UPDATE THE USER BELOW TO THE SQL USER***********************/ /********************* Add the reader and writer permission *******************/ exec sp_addrolemember 'db_datawriter', 'RealMagnet'; exec sp_addrolemember 'db_datareader', 'RealMagnet'; /********************* Grant the Execute permission on Stored Procs ***********/ GRANT EXECUTE ON OBJECT::dbo.RealMagnet_GetEntities TO RealMagnet; GRANT EXECUTE ON OBJECT::dbo.RealMagnet_GetFields TO RealMagnet; GRANT EXECUTE ON OBJECT::dbo.RealMagnet_GetInterestAreas TO RealMagnet; GRANT EXECUTE ON OBJECT::dbo.RealMagnet_GetQueries TO RealMagnet; GRANT EXECUTE ON OBJECT::dbo.RealMagnet_GetQueryData TO RealMagnet; GRANT EXECUTE ON OBJECT::dbo.RealMagnet_InsertTrackingActivity TO RealMagnet; GRANT EXECUTE ON OBJECT::dbo.RealMagnet_UpdateInterestAreaSubscription TO RealMagnet; GRANT EXECUTE, ALTER ON OBJECT::dbo.RealMagnet_InsertProspect TO RealMagnet; --/*** Errors ***/ IF @@ERROR <> 0 BEGIN ROLLBACK TRAN LoginCreation END COMMIT TRANSACTION LoginCreation END GO