Orphaned SQL Users Script

07/19/2024 11:19 am EDT

--Use this script to fix permissions for SQL Server SedonaUser and Sedona Reports

DECLARE @DatabaseName varchar(100), @SqlStatement varchar(1024)
SET ROWCOUNT 1
SELECT @DatabaseName = NAME FROM SYSDATABASES ORDER BY NAME
WHILE @@ROWCOUNT > 0
BEGIN
SET @SqlStatement = 'sp_change_users_login ''Auto_Fix'', ''SedonaUser'''
SELECT @SqlStatement = 'Use [' + @DatabaseName + '] exec ' + @SqlStatement
PRINT (@SqlStatement)
EXEC (@SqlStatement)
SELECT @DatabaseName = NAME FROM SYSDATABASES WHERE NAME > @DatabaseName ORDER BY NAME
END
SET ROWCOUNT 0
GO

DECLARE @DatabaseName varchar(100), @SqlStatement varchar(1024)
SET ROWCOUNT 1
SELECT @DatabaseName = NAME FROM SYSDATABASES ORDER BY NAME
WHILE @@ROWCOUNT > 0
BEGIN
SET @SqlStatement = 'sp_change_users_login ''Auto_Fix'', ''SedonaReports'''
SELECT @SqlStatement = 'Use [' + @DatabaseName + '] exec ' + @SqlStatement
PRINT (@SqlStatement)
EXEC (@SqlStatement)
SELECT @DatabaseName = NAME FROM SYSDATABASES WHERE NAME > @DatabaseName ORDER BY NAME
END
SET ROWCOUNT 0
GO

Was this article helpful?