Fundamental problem
Yes, the database table is set up properly. I'm looking to find any indication that, in the process of working with four different client security files (they just couldn't make up their mind) and naming the field userLevel and UserLevel if the system hasn't somehow got the wrong value in the lookup.
I don't know where to find that exactly. None of the security levels work...1, 2 or 3. They did work some days ago before another table switch for the client. I deleted files created by the Wizard and re-ran SecurityAssist; I re-loaded all of the objects in the SecurityAssist folder. Since then, authorization works for login but the user level is ignored.
I think I'll go back and delete all of the objects for SecurityAssist and re-run the wizard, then reload and see what happens. I think this is my problem, or mine along with Bill Gates. :)