I need to access the livecycle database and manually update fields in a couple of database tables(basically, need to reset some user passwords).Can some advise regarding , whether or not i can access livecycle database using tools like toad or sql developer, and if yes how?
Regarding changing the password through LC admin console,Thats the very problem, the livecycle admin password has been lost , and its the same that I am trying to reset through the database, so that i could login and change a few configurations.
Actually i am using somebody else's installation and not able to figure out what database has been configured. I am kinda new to livecycle, is there a way I could find out what database is currently used and its location?
I hope you found a wait to query your database tables.
As a temporary fix you can open and edcprincipalentity table and look for the Supper Admin account. Grab the id for that record and then open edcprincipaluserentity. Query the uidstring field and you will find 2 entries for administrator. Change the one associated with the id you grabbed above to administrator1. This way you will login with adminstrator1 from now on.