Difference between revisions of "Knowledge:Convert database users to ldap"

From OpenKM Documentation
Jump to: navigation, search
 
(2 intermediate revisions by the same user not shown)
Line 6: Line 6:
 
SELECT 'INSERT INTO OKM_USER_ROLE (UR_USER, UR_ROLE) VALUES (''' || 'newname'|| ''', ''' || UR_ROLE || ''');' FROM OKM_USER_ROLE where UR_USER='oldername';
 
SELECT 'INSERT INTO OKM_USER_ROLE (UR_USER, UR_ROLE) VALUES (''' || 'newname'|| ''', ''' || UR_ROLE || ''');' FROM OKM_USER_ROLE where UR_USER='oldername';
 
SELECT 'INSERT INTO OKM_USER_CONFIG (UC_USER, UC_HOME_PATH, UC_HOME_NODE, UC_HOME_TYPE, UC_PROFILE) VALUES (''' || 'newname' || ''', ''' || UC_HOME_PATH || ''', ''' || UC_HOME_NODE || ''', ''' || UC_HOME_TYPE  || ''');' FROM OKM_USER_CONFIG WHERE UC_USER='oldername';
 
SELECT 'INSERT INTO OKM_USER_CONFIG (UC_USER, UC_HOME_PATH, UC_HOME_NODE, UC_HOME_TYPE, UC_PROFILE) VALUES (''' || 'newname' || ''', ''' || UC_HOME_PATH || ''', ''' || UC_HOME_NODE || ''', ''' || UC_HOME_TYPE  || ''');' FROM OKM_USER_CONFIG WHERE UC_USER='oldername';
 +
</source>
 +
 +
Updating some tables:
 +
'''ALERT''' there're two non controled tables OKM_USER_NODE and OKM_USER_NODE_KEYWORDS
 +
<source lang="sql">
 +
UPDATE OKM_USER_ITEMS SET UI_USER='newname' where UI_USER='oldername';
 +
UPDATE OKM_NODE_USER_PERMISSION SET NUP_USER='newname' where NUP_USER='oldername'
 +
</source>
 +
 +
Then should delete older users:
 +
<source lang="sql">
 +
delete FROM OKM_USER_ROLE where UR_USER='oldername';
 +
delete FROM OKM_USER where USR_ID = 'oldername';
 +
</source>
 +
 +
== Script para renombrar las carpetas base del usuario ==
 +
<source lang="java">
 +
import com.openkm.api.OKMFolder;
 +
 +
String olderName = "fguasch";
 +
String newName = "fernando.guasch";
 +
OKMFolder.getInstance().rename(null, "/okm:personal/"+olderName, newName);
 +
OKMFolder.getInstance().rename(null, "/okm:trash/"+olderName, newName);
 +
OKMFolder.getInstance().rename(null, "/okm:mail/"+olderName, newName);
 
</source>
 
</source>

Latest revision as of 12:48, 4 October 2012

ORACLE

For each user should create new user and delete older: Create new user: 

SELECT 'INSERT INTO OKM_USER (USR_ID, USR_NAME, USR_PASSWORD, USR_EMAIL, USR_ACTIVE) VALUES (''' || 'newname' || ''', ''' || USR_NAME || ''', ''' || USR_PASSWORD || ''', ''' || USR_EMAIL || ''', ''' || USR_ACTIVE || ''');' FROM OKM_USER  WHERE USR_ID='oldername';
SELECT 'INSERT INTO OKM_USER_ROLE (UR_USER, UR_ROLE) VALUES (''' || 'newname'|| ''', ''' || UR_ROLE || ''');' FROM OKM_USER_ROLE where UR_USER='oldername';
SELECT 'INSERT INTO OKM_USER_CONFIG (UC_USER, UC_HOME_PATH, UC_HOME_NODE, UC_HOME_TYPE, UC_PROFILE) VALUES (''' || 'newname' || ''', ''' || UC_HOME_PATH || ''', ''' || UC_HOME_NODE || ''', ''' || UC_HOME_TYPE  || ''');' FROM OKM_USER_CONFIG WHERE UC_USER='oldername';

Updating some tables: ALERT there're two non controled tables OKM_USER_NODE and OKM_USER_NODE_KEYWORDS 

UPDATE OKM_USER_ITEMS SET UI_USER='newname' where UI_USER='oldername';
UPDATE OKM_NODE_USER_PERMISSION SET NUP_USER='newname' where NUP_USER='oldername'

Then should delete older users: 

delete FROM OKM_USER_ROLE where UR_USER='oldername';
delete FROM OKM_USER where USR_ID = 'oldername';

Script para renombrar las carpetas base del usuario

import com.openkm.api.OKMFolder;

String olderName = "fguasch";
String newName = "fernando.guasch";
OKMFolder.getInstance().rename(null, "/okm:personal/"+olderName, newName);
OKMFolder.getInstance().rename(null, "/okm:trash/"+olderName, newName);
OKMFolder.getInstance().rename(null, "/okm:mail/"+olderName, newName);
Retrieved from "https://www.openkm.com/wiki/index.php?title=Knowledge:Convert_database_users_to_ldap&oldid=7315"