Notebook execution failed at Notebook service with http status code - '200'

I'm encountering the same issue with pipeline execution. The pipeline runs the notebook, of which I am the creator and therefore the owner. The notebook is located in Workspace A, but it references a table in Workspace B.

If I'm absent from work and my colleague executes the pipeline without access to Workspace B, it fails with the error: 'table or view does not exist, or a column within a table or view that does not exist.'

What would be the appropriate approach to address this issue?

Perhaps using a service account when creating notebooks?

Can the owner of the notebook be changed after it has been created?