I've been beating my head against the wall on this one for over a year, and opened a few support tickets with Laserfiche, but still don't have a resolution. Hopefully someone in the community has run into this and found a fix!
My Oracle skills are not great, so please correct me if I get any of the terminology wrong.
We have an Oracle data source for our Laserfiche forms that has thousands of tables and views in the table dropdown in Lookup Rules. However, the account we use to log into the data source only has access to a total of 45 tables and views from the entire database.
It's as if Laserfiche Forms is using PUBLIC SYNONYMS instead of just the schema assigned to that specific user account. So we get a listing of thousands of tables and views that Forms can't actually use.
In addition to making forms development really annoying and slow it causes the sync process and importing new processes from our test server to our production server really slow and prone to crashing.
Is there a setting or change I can make in either Forms or Oracle to fix this?
We are self hosted and on Laserfiche Forms 11 Update 2. I'll be testing update 3 soon.