APEX

Hi,

I'm sure that this question has been asked over and over by different people. If I have a common user table (PERS) and a couple of tables (PERS_APP_ROLE, ...) to store user roles in a schema in one standalone database - Oracle, of course. I have a separate APEX application that handles self-service things like user changing their password or personal information. Then, I have multiple APEX applications, residing in different databases, that authenticate against the user tables in the above remote database schema - via database link. In addition, I log the numeric ID of the user who creates and updates the records in many of these applications. Therefore, in many pages of these applications, I need to query the remote database in order to get the user name of these ID's.

In the PERS table in the remote database, I store both the LDAP Active Directory usernames (for LDAP authentication in APEX) and the "hashed" passwords (for table authentication in APEX) because my applications are used by both internal and external users.

Is this the correct approach to handle these mixed authentication needs - LDAP and table authentication? Can anyone help?

Thanks.

Andy