如何进行 SQL Server 批理修改权限

IF OBJECT_ID("ChangeAll") IS NOT NULL Drop PROC ChangeAll
         GO 

         Create PROCEDURE ChangeAll (
             @old sysname,
             @new sysname
         )
        AS
             DECLARE @objname sysname 

             SET NOCOUNT ON 

             IF USER_ID(@old) IS NULL
                BEGIN
                    RAISERROR ("The @old passed 
                does not exist in the database", 16, 1)
                    RETURN
                END
             IF USER_ID(@new) IS NULL
                BEGIN
                    RAISERROR ("The @new passed 
                does not exist in the database", 16, 1)
                    RETURN
                END 

             DECLARE owner_cursor CURSOR FOR 

             Select name FROM sysobjects 
              Where uid = USER_ID(@old)
             OPEN owner_cursor
             FETCH NEXT FROM owner_cursor INTO @objname
             WHILE (@@fetch_status <> -1)
                 BEGIN
                     SET @objname = @old + "." + @objname
                     EXEC sp_changeobjectowner @objname, @new
                     FETCH NEXT FROM owner_cursor INTO @objname
                 END 

            CLOSE owner_cursor
            DEALLOCATE owner_cursorz
            GO 

             EXEC ChangeAll @old = "mooip", @new = "dbo"