I wish to configure a workstation so that I insert a CAC or smart card in the card reader and have Oracle recognize the certificate and build an SSL authenticated connection. Is this supported in SQL*Plus or with a thick client CONNECT string? How would I do it?
Note: I have already set up an SSL connection using chained certificates stored in wallets. I set up both a client and server wallet and stored certificates in them. Then I created a user that was externally identified by a certificate DN. The user logs in by starting SQL*Plus and then performing "CONNECT /@databasename.domain.net. All this works great. But instead of the having it pick up the certificates fro the client wallet I want Oracle to pick them up from a smart card and authenticate with that. I've read a lot of cases of where users are creating web based applications that work with CAC but not much on SQL*Plus based CAC. The reason I want to use SQL*Plus based CAC is that we have some thick clients that use the CONNECT statement to connect to the Oracle database.