Thanks for your reply, Nayan.

I'll try option 1 and report back later.

Is option 2 possible? As per the second error message, it does not appear as if we can change the owner on streaming tables.

Option 3 would be too complex and time-consuming, but thanks for the idea.