Home sharing from more than one apple id?

My wife recently snagged herself an iPad Pro so we gave her older iPad to our son. She already had a bunch of apps that he used regularly so we set up Home Sharing from her apple id to his (we set him up with his own id as well).

I have my own iPad which he's used in the past to watch movies when we've gone away on holidays so now I'd like to be able to make some of that content available to him on his own iPad. So my questions is can we set up his iPad to be Home Sharing from both my and my wife's apple id's? This way he can use the selected content from either stuff my wife has purchased, or stuff I have purchased in the past.

Thanks!