My Oracle Support Banner

Is It Possible To Use Stored Procedure To Fetch Password In Security Realm? (Doc ID 2630536.1)

Last updated on SEPTEMBER 29, 2023

Applies to:

Oracle Communications Converged Application Server - Version 5.1.0 and later
Information in this document applies to any platform.


Set the Security Realm following the steps:

1, On Admin Console, under the domain, click 'Security Realms' --> myrealm --> Providers.

2, On the page, click 'SQLAuthenticator' --> 'Provider Specific'.

3, On the page, modify the 'SQL Get Users Password' as 'SELECT AKEY FROM MEMBER WHERE USERID = ?'.

Is it possible to change the SQL command(SELECT AKEY FROM MEMBER WHERE USERID = ?) to stored procedure?


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

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