Separate instance....still okay to run the command:
usp_Jiwa_Grant_Application_Permissions 'JiwaUser'
GO
usp_Jiwa_Grant_Reporting_Permissions 'JiwaReports'
GO
Luehman wrote:Separate instance....still okay to run the command:
usp_Jiwa_Grant_Application_Permissions 'JiwaUser'
GO
usp_Jiwa_Grant_Reporting_Permissions 'JiwaReports'
GO
DROP USER JiwaLogin
DROP USER JiwaReports
DROP USER JiwaUser
GO
CREATE USER JiwaLogin FOR LOGIN JiwaLogin
CREATE USER JiwaReports FOR LOGIN JiwaReports
CREATE USER JiwaUser FOR LOGIN JiwaUser
GO
UPDATE HR_Staff
SET SQLLogin = '6B4A7C2B2E902402268692E8932CDB50',
SQLPassword = '1C57594FC45BBF79E1CB63D5452D4EE364CB73ED467F7C8C',
ReportSQLLogin = '887BFFE23AB10B3C5412655265278A11',
ReportSQLPassword = '1C57594FC45BBF79E1CB63D5452D4EE364CB73ED467F7C8C',
SQLLoginLastSavedDateTime = '2014-05-28 11:20:48.000',
ReportsLoginLastSavedDateTime = '2014-05-28 11:20:48.000'
WHERE UserName = 'Admin'
GO
-- Set Jiwa Password
UPDATE HR_Staff SET Password = '60A889064BAD474508723B9200184D09',
PasswordLastChangedDateTime = '2014-05-28 11:20:48.000',
LastSavedDateTime = '2014-05-28 11:20:48.000',
SQLLogin = '6B4A7C2B2E902402268692E8932CDB50',
SQLPassword = '1C57594FC45BBF79E1CB63D5452D4EE364CB73ED467F7C8C',
ReportSQLLogin = '887BFFE23AB10B3C5412655265278A11',
ReportSQLPassword = '1C57594FC45BBF79E1CB63D5452D4EE364CB73ED467F7C8C'
WHERE UserName = 'Admin'
GO
usp_Jiwa_Grant_Application_Permissions 'JiwaUser'
GO
usp_Jiwa_Grant_Reporting_Permissions 'JiwaReports'
GO
update hr_staff set SQLLogin = (SELECT TOP 1 SQLLogin FROM JiwaDemo.dbo.HR_Staff)
update hr_staff set SQLPassword = (SELECT TOP 1 SQLPassword FROM JiwaDemo.dbo.HR_Staff)
update hr_staff set ReportSQLLogin = (SELECT TOP 1 ReportSQLLogin FROM JiwaDemo.dbo.HR_Staff)
update hr_staff set ReportSQLPassword = (SELECT TOP 1 ReportSQLPassword FROM JiwaDemo.dbo.HR_Staff)
update hr_staff set SQLLoginLastSavedDateTime = (SELECT TOP 1 SQLLoginLastSavedDateTime FROM JiwaDemo.dbo.HR_Staff)
update hr_staff set ReportsLoginLastSavedDateTime = (SELECT TOP 1 ReportsLoginLastSavedDateTime FROM JiwaDemo.dbo.HR_Staff)
EXEC sp_change_users_login 'Auto_Fix', 'JiwaUser'
EXEC sp_change_users_login 'Auto_Fix', 'JiwaLogin'
EXEC sp_change_users_login 'Auto_Fix', 'JiwaReports'
Return to Technical and or Programming
Users browsing this forum: No registered users and 12 guests