Hi all. I'm on APEX 22.2.6.
I'm migrating a forms application to APEX. Requirement is to use LDAP authentication.
In my old forms application there is a user table where I can have the same user with 2 different profile (for example basic user and advanced user).
I have tested successfully LDAP connection, but my objective is that after user login to application using LDAP I must check the user table and if a user has 2 profiles, I must show a modal page where the user can choose the profile that want to use; if a user has only 1 profile in the user table, then I must go to application homepage.
How can I check how many profiles in the user table after connecting using LDAP?
Thanks for collaboration,
Fabrizio