Moving off LDAP OM Web Viewer 12.1

Products

• Output Management Web Viewer

Issue/Introduction

I've been charged to stop using LDAP.  We have RACF profiles built that can be used to authenticate.  The users on our development system had to either be deleted to get rebuilt at signon, or we give them the default user profile and they had to change their config to use that profile. We have 9000+ users registered in our Prod system, but only maybe 300+ that are active.

My questions:

1. Is there a script that I could use to add 'Default User' to all profiles? 
2. Could I use a script to change the logon preference to 'Default user' for all users except the admins?
3. Is there a script to delete inactive users?
4. Is there a report to identify inactive users, or list users by last logon date?

I am trying to lessen the manual effort to make this change. 

Environment

Output Management Web Viewer 12.1
LDAP

Resolution

Updates to the user table in the Web Viewer database are made manually, one at a time. There are not scripts for making changes.

1. Export the Users table
2. Modify it to add the Default User Role for all users.
3. In WVProfile.properties, set AUTHENTICATION.LDAPPrefConnect=0
4. Delete all LDAP Directories from Web Viewer, Administration, Directory.