OraFAQ Forum: Security » Cobol program that accesses Oracle database

Home » RDBMS Server » Security » Cobol program that accesses Oracle database

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Cobol program that accesses Oracle database [message #408777]

Wed, 17 June 2009 15:19

aft5425
Messages: 5
Registered: October 2008

Junior Member

I have a MicroFocus Cobol program that executes on a unix (HP-UX) and accesses an oracle database (9.2.0.5). In the test environment, we hardcode the specific userid and password in the program that should be used in querying the oracle database.

However, in production, we don't want to hardcode the specific userid and password to access the oracle database with. How can we modify the program or the userid for production to know which userid and password to use to query the database?

Technically, we can get the program to use the correct userid in production. But is there something we need to do to the userid or the oracle database so that the userid doesn't need a password in production?

Report message to a moderator

Re: Cobol [message #408787 is a reply to message #408777]

Wed, 17 June 2009 15:56

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Search for "OPS$" (Operating System Authenticated user); perhaps it'll help.

Report message to a moderator

Re: Cobol [message #408790 is a reply to message #408787]

Wed, 17 June 2009 16:19

andrew again
Messages: 2577
Registered: March 2000

Senior Member

Yes, OPS$ could help but creates loopholes. Reading user & pass from an external file and using those values in your cobol program would be a more common solution. I bet all your other clients supply their own user/pass.

Report message to a moderator