CDSW change owner Projects

[#1]

Hi,
can you tell me if it is possible to change the owner of a project in cdsw? And how?

Many thanks

[#2]

@Mike @Gopinath Hi! Do you have some insights here? Thanks!

[#3]

@MID_ACN there is no straightforward way to do it.

Option#1: Forking [through UI]
https://community.cloudera.com/t5/Internal/How-to-change-the-owner-of-the-project-in-CML/ta-p/360168

Option#2: Projects table update [requires cli access to the underlying pod]
step1: connect to postgres DB
kubectl exec -it $(kubectl get pods -l role=db -o jsonpath='{.items[*].metadata.name}') -- psql -P pager=off --expanded -U sense

step2: get user IDs, project ID
select id from users where username='<old_owner>';
select id from users where username='<new_owner>';
select id,creator_id,user_id from projects where name='<project_name>';

step#3: update projects table
select id,name,user_id,creator_id from projects where project_id='<project_id>'; #validate before update]
update projects set user_id='new_owner_id', creator_id='new_owner_id' where project_id='<project_id>'; #update