Page 1 of 1

Permissions mass edit

PostPosted:Wed Jan 16, 2013 9:22 am
by 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

Re: Permissions mass edit

PostPosted:Fri Jan 18, 2013 5:52 pm
by 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 ?

Re: Permissions mass edit

PostPosted:Mon Jan 21, 2013 10:55 am
by 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.

Re: Permissions mass edit

PostPosted:Thu Jan 24, 2013 3:52 pm
by 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';