Skip to Main Content
Forums

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to Perform Client SSL Certificate Authentication from PL SQL

user8864023Nov 1 2021

Hi All -
We have a use case where we are integrating with one of the bank. We will be using rest services for integration & authentication will be OAUTH (2L). On top of 2L, bank wanted us to have Client SSL Certificate authentication as well.
We have been performing similar connections via UTL_HTTP for other integrations but never did Client SSL Certificate Authentication.
Can anyone suggest steps/sample code achieve client SSS Certificate authentication from database.
Thanks in Advance.
This post has been answered by Jason_(A_Non) on Nov 2 2021
Jump to Answer

Comments

Jason_(A_Non)
Answer

I'll assume you can make a HTTPS call so you have a wallet setup and know about ACLs. Here's one prior discussion on this topic I recall having
https://community.oracle.com/tech/developers/discussion/comment/16773526#Comment_16773526
My version works for 11.2 and prior and the answer by PaulZip works for 12c and later.

Marked as Answer by user8864023 · Nov 3 2021
2 people found this helpful
user8864023

Thanks, i will try and get back !

1 person found this helpful
1 - 2

Post Details

Added on Nov 1 2021
#database-security, #database-security-general, #ssl
2 comments
1,313 views