Inconsistent MetaSolv Solution Security module behaviors when configured to use Active Directory provider authentication versus Oracle database user account authentication (Doc ID 2049733.1)

Last updated on JUNE 05, 2023

Applies to:

Symptoms

MetaSolv Solution Security module behaviors are inconsistent when the system is configured to use Active Directory provider/Lightweight Directory Access Protocol authentication instead of the standard Oracle database user account authentication.

1. When creating a new user account using the 'New -> User' function, the system will create a record in SECURITY_USERS, but it does not create an Oracle account for the user ID. This allows for a log in to the core MSS client since the user is authenticated against the Lightweight Directory Access Protocol source, however this user will not be able to connect to MSS Utilities since an Oracle account is required for authentication. There is no method in Security to create this account other than manually creating the account in the database.

2. When using the 'New From' function, the application will create a user account no matter if the system is using Active Directory provider/Lightweight Directory Access Protocol authentication or Oracle database user account authentication.

3. The "pass word Expires On" field is hidden from the user maintenance window when the user has logged in via Lightweight Directory Access Protocol authentication. A value is still set to the SECURITY_USERS table, but this value is not exposed in the application. Since we need to manage the Oracle account for MSS Utilities purposes, this value needs to be made available.

4. The "pass word" and "Confirm pass word" fields are both displayed as required (in blue), but the window can be closed and the user successfully created even if they are left blank. If the cursor is placed into one of the fields, it requires a value before the user can leave the field. Since no Oracle user record is being created, whatever information is entered into these fields is lost.

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.