Change Query Table Owners
The Change Query Table Owner option lets you assign new owners to tables defined in a query.
To assign new owners to tables defined in a query
1. Select a table in the Query Definition pane of the Query Editor.
2. Select a table with the same name from the Tables List.
3. Click Edit, Change Query Table Owner in the Query Editor.
Important! Changing ownership of a query table may invalidate existing join definitions. It is the user's responsibility to verify that existing join definitions are still valid.