Created On: 17 November 2010
Problem:
Is it possible to connect to Oracle using OS, or External, authentication, rather than specifying an explicit user ID and password?
Resolution:
Yes. You firstly need to enable External authentication both server-side, and also client-side (in your network configuration). Oracle cover this within Chapter 10 of their Advanced Security Administrator's Guide.
Having configured this -- and verified that it works correctly outside of your COBOL environment, for example, using Oracle's sqlplus utility, you can amend your SQL CONNECT statement to utilise OS authentication by specifying a username/password of / , i.e.
EXEC SQL
CONNECT TO MyServerAlias USER /
END-EXEC
Having configured this -- and verified that it works correctly outside of your COBOL environment, for example, using Oracle's sqlplus utility, you can amend your SQL CONNECT statement to utilise OS authentication by specifying a username/password of / , i.e.
EXEC SQL
CONNECT TO MyServerAlias USER /
END-EXEC
Old KB# 32550
