Permissions mass edit

[rek25]

Hi,
I have openkm integrated with AD, everything is working fine no complains, but one of the user got name changed (she got married and desired to show new name to everybody) in Active Directory.
After that user lost access to files folders in repository. How can I automagically replace old login with new on in Open KM ? Can someone point me in right direction as i dont see in database any permission table where i can change that.

Open KM > 5.1
MYSQL repository
Linux server

[jllort]

For what I understood you changed username login to other in your ldap and now your user can not access to the files. confirm I understood the problem ?

[rek25]

Hi,
indeed, user can log in, create new items etc. but can't access old one because there is still old user name on security.

[jllort]

Some work by administrator should be done here.
1- First change node names under personal, trash and mail and recursivelly change grants is this nodes too
2- Then change specific repository users grants with sql like:

Code: Select all

update OKM_NODE_USER_PERMISSION set NUP_USER='older_name' where NUP_USER='new_name';