Hi all,
I'm hoping someone can assist to help me with an LDAP query.
Basically, my Apex application uses LDAP authentication. Works fine, no issues there.
What I also need to do is load the users attributes from LDAP each time they log in. I want to store these attributes as a variable of some sort, so that they can be queried as needed on different Apex pl/sql processes. I don't want to store these user details in a table, as some of them change on a regular basis (think groups, business role etc) and the application will default it's display based on some of these settings, so they need to be dynamic.
I found this page that shows some basic code for connecting to and searching the LDAP directory, which makes sense. I can open a LDAP connection and use LDAP_SEARCH with an anonymous connection.
I'm unsure how I can take the results of this and store them in something that will persist for the duration of the users session. Once they log out or their session times-out, the data is free to go on it's merry way into the void.
I also need any functions/procedures and declared types to reside inside a package, which may affect how this is declared? I'd prefer not to just load into a collection, unless it's recommended.
Is it possible to just load all attributes into some sort of array which will persist for the session?
Apex is 4.2.
Oracle DB is 11g.
Thanks!