sql7, user di semua database

/*
— hapus dulu usernya
exec sp_droplogin zz
— buat user lagi
exec sp_addsrvrolemember zz, sysadmin
*/

–exec sp_addsrvrolemember N’zz’, sysadmin

declare @db varchar(50), @sql nvarchar (1000)

declare dbx cursor for
select name from sysdatabases
open dbx
fetch from dbx into @db
while @@fetch_status = 0
begin
— add user sebagai dbo
–exec sp_addrolemember N’db_owner’, N’zz’
set @sql = N’use ‘ + @db + ‘ exec sp_revokedbaccess zz’
set @sql = N’use ‘ + @db + ‘ exec sp_grantdbaccess zz’
set @sql = N’use ‘ + @db + ‘ exec sp_addrolemember db_owner, zz’

–print @sql
exec (@sql)

fetch next from dbx into @db
end
close dbx
deallocate dbx