question Re: CDSW change owner Projects in Support Questions

CDSW change owner Projects

MID_ACN — Tue, 21 Apr 2026 06:22:08 GMT

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

Many thanks

Re: CDSW change owner Projects

DianaTorres — Wed, 15 Jan 2025 01:52:34 GMT

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

Re: CDSW change owner Projects

Gopinath — Wed, 15 Jan 2025 03:48:12 GMT

@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

Re: CDSW change owner Projects

DianaTorres — Wed, 22 Jan 2025 00:39:19 GMT

@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.