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

[#4]

@MID_ACN Has the reply helped resolve your issue? If so, please mark the appropriate reply as the solution, as it will make it easier for others to find the answer in the future.  Thanks.