7. Mai 2010 15:36
8. Mai 2010 14:57
USE [Navision] -- change db
SET STATISTICS IO OFF
SET NOCOUNT ON
GO
PRINT 'USE "master"'
PRINT 'GO'
PRINT ''
DECLARE @user VARCHAR(30), @type varchar(10), @tsql VARCHAR(1000)
DECLARE user_cur CURSOR FAST_FORWARD FOR
SELECT "name", "type" FROM sys.database_principals
WHERE "type" IN ('S', 'U')
AND "name" NOT IN ('dbo', 'guest', 'INFORMATION_SCHEMA', 'sys')
ORDER BY "name"
OPEN user_cur
FETCH NEXT FROM user_cur INTO @user, @type
WHILE @@FETCH_STATUS = 0 BEGIN
SET @tsql =
'IF NOT EXISTS(SELECT TOP 1 NULL FROM sys.server_principals WHERE "type" IN (''S'', ''U'') AND "name" = ''' + @user + ''')
EXEC sp_addlogin @loginame = ''' + @user + ''''
IF @type = 'S'
SET @tsql = @tsql + ', @passwd = ''welcome'''
PRINT @tsql
PRINT 'GO'
FETCH NEXT FROM user_cur INTO @user, @type
END
CLOSE user_cur
DEALLOCATE user_cur
-- Copy output-script and execute as new query
-- PROVIDED "AS IS". NO WARRANTY, NO GUARANTEE, NO SUPPORT.
10. Mai 2010 17:18
IF NOT EXISTS(SELECT TOP 1 NULL FROM sys.server_principals WHERE "type" IN ('S', 'U') AND "name" = 'KFranz')
EXEC sp_addlogin @loginame = 'KFranz', @passwd = ''
GO
WHERE "type" IN ('S', 'U')
10. Mai 2010 17:42
AndreasD hat geschrieben:Tatsächlich wurde dem User name der Login name aber nicht hinzugefügt.