Project Ownership on TeamServer

Submitted by kidder on Thu, 01/09/2020 - 15:02
Hello
we have a project that was created by a member of staff that has now left. As the creator they shared the project to me (but not to other members of staff). I am only a collaborator on the project so do not seem to have the permissions to share it. Is there any way around this issue?

Hi kidder,

Unfortunately, we don't currently provide a way to change the owner of a shared project within the studio.

Given that you already have access to the project, one option that may work for you is to export the project, and then re import it under a new name. You can then be the owner of this new project and share it with the relevant people.
The downsides of this approach are that you will lose the history of the project, and it will now have a new name. You can still configure it to publish to the same location, but if you have any inter project setup etc then this would need to be updated.

Do you think this approach would work for you?

If not, the only option I can think of would be to manually adjust the Team Sever database. This is not something we generally recommend due to the ability to easily break things, but let me know if you would like to try this, and I can find out what would need to be changed.

Regards,
Gerard

Hi kidder,

Hopefully the following steps will let you change the project ownership by manipulating the database directly:

  1. Disconnect from the Team Server in the studio if it is currently connected, and close any open projects.
  2. Shut down the Team Server Tomcat, and take a backup of the database directory.
  3. Use the information at the end of this documentation page to access the Team Sever database. https://www.hyfinity.com/docs/hyfinity/v9-5/Common/TeamServer/Configuring%20Authentication.html
  4. Determine the ProjectID on the Team Server for the project in question b y querying the Project table.
  5. Determine the UserID of the current project owner by querying the User table.
  6. Determine the UserID of the current collaborator user that you want to become the owner by querying the User table.
  7. Check the current access settings for the project by querying the ProjectSubscriber table.
    Select * from ProjectSubscriber where ProjectID = <Project Id determined in step 4>
  8. Change the existing owner to subscriber
    Update ProjectSubscriber set RoleName = 'subscriber' where ProjectID = <Project Id determined in step 4> and UserID = <User Id determined in step 5>
  9. Change the existing collaborator to owner
    Update ProjectSubscriber set RoleName = 'owner' where ProjectID = <Project Id determined in step 4> and UserID = <User Id determined in step 6>
  10. Restart the Tomcat for the Team Server
  11. Restart the studio and reconnect to the Team Server.
  12. Reopen the project in question and the status should update.


I hope this helps. Please let me know what approach you decide to take, and how you get on with it.

Regards,
Gerard

We use cookies and analytics on our website to support technical features that enhance your user experience.

-