Has anybody been able to reassign an entire T-Stats workspace to another user? Is it possible? Could it be as simple as updating the user id in the workspace table of our TStatsConfig db?
I have a bunch of reports I've built that I'd like to completely hand over to somebody else, but/and the "Share Report" button is causing an application error I don't really have time to troubleshoot at the moment.
Matthew,
There is a T-Stats group that you should look at as JCA has posted a number of articles there - great source of information.
As to your question, yes it is possible. I did this when one of our employees left.
Normal 0 false false false EN-US X-NONE X-NONE
Connect to TStatsConfig database and run the following select queries to identify the workspace that should be transferred and the user to whom it should be transferred.
Select * from JcaUser
Select * from Workspace
UPDATE workspace
Set UserId = XX --replace XX with the ID from the JcaUser table of the user to whom the workspace is being transferred
Where UserId = YY --replace YY with the UserId from the Workspace table of the workspace that is being transferred
Thanks Michele! Both great tips.