Kintana Script : Set LDAP Authentication Mode

Purpose

When switching to LDAP authentication you need to keep the admin user accounts on the native Kintana password check.

That way, if the LDAP server goes down you will still be able to log in.

Tested

With HP PPM (Project and Portfolio Management) Kintana v6.0.

Usage

Paste the script into Toad or SQL Runner

select authentication_mode
from KNTA_USERS
where  end_date is NULL
  and  username != 'admin'
  and username != 'ADMIN1'
  and username != 'ADMIN2'
order by username
/pre>

update KNTA_USERS
set authentication_mode = 'LDAP'
where  end_date is NULL
  and username != 'admin'
  and username != 'ADMIN1'
  and username != 'ADMIN2'


commit;


          

Download

KintanaScripts.zip (79 Kb)