Configure a SQL Authenticator Using the Oracle WebLogic Server Administration Console

A user with the appropriate privileges can log in to the Oracle WebLogic Server Administration Console using the WebLogic database authenticator.

When creating the SQL authenticator, select the read-only SQL authenticator. The read-only authentication provider type does not write back to the database.

When entering the SQL statements in the Provider Specific tab, if your password column is in plain text as the result of the query supplied for the SQL Get Users Password column was not hashed or encrypted, select the Plaintext Password Enabled option.

If the Plaintext Password Enabled option is cleared, the SQLAuthenticator expects passwords hashed using SHA-1, default encryption algorithm. For more information on the supported encryption algorithms, see the documentation for the base SQLAuthenticator Mbean PasswordAlgorithm attribute.

See SQL Authenticator Select Statement Reference for help in defining the Provider Specific SQL statements.
  1. Log in to Oracle WebLogic Server Administration Console.
  2. In the Change Center, click Lock & Edit.
  3. From Domain Structure, select Security Realms and click myrealm.
  4. In Settings for myrealm, click the Providers tab, and then click the Authentication tab.
  5. In Authentication Providers, click New.
  6. In Create a New Authentication Provider, in Name type a name for the authentication providers such as UserGroupDBAuthenticator.
  7. From the Type list, select ReadOnlySQLAuthenticator, and click OK.
  8. From the Authentication Providers table, select the provider you just created.
  9. In the Settings for <your new authentication provider name>, click the Provider Specific tab.
  10. Optional: In the Provider Specific tab, if your password column is in plain text, select Plaintext Password Enabled.
  11. In the Data Source Name field, type the name of an existing data source, for example, UserGroupsDS, to use this authentication provider.
    The data source name must match the existing data sources defined in Oracle WebLogic Server Administration Console.
  12. In the Provider Specific tab, specify the SQL statements used to authenticate user access and to query your database tables.
  13. After entering all of the required SQL statements for your authenticator, click Save.
You must configure the authentication provider control flag when using multiple authentication providers.