Difference between revisions of "Knowledge:Convert database users to ldap"
From OpenKM Documentation
| Line 4: | Line 4: | ||
<source lang="sql"> | <source lang="sql"> | ||
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 (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'|| ''', '' | + | 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> | </source> | ||
Revision as of 12:32, 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';
