Difference between revisions of "Knowledge:Convert database users to ldap"
From OpenKM Documentation
(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…') |
(No difference)
|
Revision as of 13:05, 4 October 2012
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';