Knowledge:Convert database users to ldap
From OpenKM Documentation
Revision as of 12:05, 4 October 2012 by Jllort (talk | contribs) (Created page with '===ORACLE=== For each user should create new user and delete older: <source lang="sql"> SELECT 'INSERT INTO OKM_USER (USR_ID, USR_NAME, USR_PASSWORD, USR_EMAIL, USR_ACTIVE) VALUE…')
ORACLE
For each user should create new user and delete older:
SELECT 'INSERT INTO OKM_USER (USR_ID, USR_NAME, USR_PASSWORD, USR_EMAIL, USR_ACTIVE) VALUES (''' || 'fernando.guasch' || ''', ''' || USR_NAME || ''', ''' || USR_PASSWORD || ''', ''' || USR_EMAIL || ''', ''' || USR_ACTIVE || ''');' FROM OKM_USER WHERE USR_ID='fguasch';
