No direct DLC transfer between accounts. Licenses bind to purchasing Xbox Live account.
Some Game of the Year / Complete editions include DLC on disc. Sharing the disc shares that content (no download needed).
For modern Xbox (One/Series), "Home Xbox" sharing works similarly but across generations.