Process Mapping Logo

Process Mapping - Forums

Sharing 19 years of knowledge and experience

 
Metastorm BPM forums
Sign up Latest Topics
 
 
 


Reply
  Author   Comment  
jpesout

Avatar / Picture

Veteran
Registered:
Posts: 107
Reply with quote  #1 
Quote:
DECLARE
  @eUserNameOld NVARCHAR(100),
  @eUserNameNew NVARCHAR(100)
 
SET @eUserNameOld = 'xxx'
SET @eUserNameNew = 'yyy'

UPDATE eUser SET eUserName = @eUserNameNew WHERE eUserName = @eUserNameOld
UPDATE eUser SET eReportsTo = @eUserNameNew WHERE eReportsTo = @eUserNameOld
UPDATE eAttribute SET eUserName = @eUserNameNew WHERE eUserName = @eUserNameOld
UPDATE eAlert SET eUserName = @eUserNameNew WHERE eUserName = @eUserNameOld
UPDATE eFolder SET eOriginator = @eUserNameNew WHERE eOriginator = @eUserNameOld
UPDATE eFolder SET eActionUser = @eUserNameNew WHERE eActionUser = @eUserNameOld
UPDATE eSession SET eUserName = @eUserNameNew WHERE eUserName = @eUserNameOld
UPDATE eLog SET eUserName = @eUserNameNew WHERE eUserName = @eUserNameOld
UPDATE eEvent SET eUserName = @eUserNameNew WHERE eUserName = @eUserNameOld

UPDATE eAssignment SET eUserName = @eUserNameNew WHERE eUserName = @eUserNameOld
UPDATE eAssignment SET eRoleName = @eUserNameNew WHERE eRoleName = @eUserNameOld



First batch of updates is taken from FreeFlow admin source codes. FreeFlow is for v7, but AFAIK nothing except the roles changed in the v9. In the v9, there is every user assigned to the role with the same name as the username and to the Everybody role - last two updates fix this.

There is no way how to updates usernames in the process and solutions tables (etc) automatically. I decided to keep and maintain stored procedure with all the references to the eUserName, but if I could start from scratch, I would probably connect every user with the folder and use the FolderID instead of eUserName.

If you know about other differences between v7 and v9, please let me know.
0
Previous Topic | Next Topic
Print
Reply

Quick Navigation:


Create your own forum with Website Toolbox!