USE master
go
BEGIN
    DECLARE @databasename VARCHAR(30)
    DECLARE cur CURSOR
        FOR SELECT
                name
            FROM
                sysdatabases
    CREATE TABLE #result
        (
         dbname VARCHAR(30)
        ,result VARCHAR(300))
    OPEN cur
    FETCH NEXT FROM cur INTO @databasename
    WHILE(@@fetch_status = 0)
        BEGIN
            CREATE TABLE #t
                (
                 [Owner] VARCHAR(50)
                ,[Object] VARCHAR(75)
                ,Grantee VARCHAR(50)
                ,Grantor VARCHAR(50)
                ,ProtectType VARCHAR(50)
                ,[Action] VARCHAR(50)
                ,[Column] VARCHAR(50))
            INSERT INTO
                #t
                EXEC sp_helprotect @username = NULL
            INSERT INTO
                #result
                SELECT
                    @databasename
                   ,ProtectType + ' ' + [Action] + ' on [' + [Owner] + '].['
                    + [Object] + ']'
                    + CASE WHEN (PATINDEX('%All%', [Column]) = 0)
                                AND ([Column] <> '.') THEN ' (' + [Column] + ')'
                           ELSE ''
                      END + ' to [' + Grantee + ']'
                FROM
                    #t
            DROP TABLE #t
            FETCH NEXT FROM cur INTO @databasename
        END
    SELECT
        *
    FROM
        #result
    ORDER BY
        dbname
    CLOSE cur
    DEALLOCATE cur
    DROP TABLE #result
END
go