Ability to handover ownership of objects (query, dashboard) to another user

[arikfr]

For cases when a user leaves the organization, admin (or the user herself) should be able to transfer the ownership to someone else.

[ikks]

The objects that should be handedover are:

• QuerySnippet
• Dashboard
• Query

Any other else?

Would be a good idea to have this coded at the beginning as a cli task? like in https://github.com/getredash/redash/blob/master/redash/cli/users.py ?

[arikfr]

Alerts and NotificationDestinations.

[dhruvprajapati]

@arikfr Is there a way to transfer ownership without it being a feature available out of the box?

[agungyuliaji]

Seems it possible to update via DB directly? Eg: change the foreign key user_id, but wondering if there is a break relationship data?

[jredblue]

@arikfr Hi Arik, I made a PR to provide functionality for updating the owner of a query if you want to check it out. I could make a similar change for updating dashboard owners as well if that is wanted.