-- Script that fixes Sedonareports and issues printing after data/server migration
IF SUSER_ID('SedonaReports') IS NULL
BEGIN
CREATE LOGIN [SedonaReports] WITH Password = '', CHECK_EXPIRATION = OFF, CHECK_POLICY = OFF;
PRINT 'Database Login Created';
END
IF USER_ID('SedonaReports') IS NULL
BEGIN
CREATE USER [SedonaReports];
PRINT 'Database User created';
END
-- sp_change_users_login ACTION , DATABASE USER , SQL SERVER LOGIN;
EXEC sp_change_users_login 'Update_One', 'SedonaReports', 'SedonaReports';
EXEC sp_addrolemember 'db_datareader', 'SedonaReports';
GRANT EXECUTE ON dbo.CalculateDueDate TO SedonaReports;
GRANT EXECUTE ON dbo.fnJob_Expense TO SedonaReports;
GRANT EXECUTE ON dbo.fnJob_ExpenseOther TO SedonaReports;
