Beefy Boxes and Bandwidth Generously Provided by pair Networks
Keep It Simple, Stupid
 
PerlMonks  

Re: sqlplus hide password

by BigJoe (Curate)
on Aug 23, 2006 at 14:28 UTC ( #569096=note: print w/ replies, xml ) Need Help??


in reply to sqlplus hide password

Personally I would ust DBI and build a simple interface. But this really depends on what you are trying to accomplish. DBI can actually do a lot of things that you can do from SQL*Plus. From the example you have here using this option would work pretty well.

Otherwise I would try Expect (http://search.cpan.org/~rgiersig/Expect-1.20/Expect.pod). you would pass the username and Database instance and expect would allow you to the then pass the password then any subsequent commands.



--BigJoe

Learn patience, you must.
Young PerlMonk, craves Not these things.
Use the source Luke.


Comment on Re: sqlplus hide password

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://569096]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others exploiting the Monastery: (6)
As of 2015-07-05 22:19 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    The top three priorities of my open tasks are (in descending order of likelihood to be worked on) ...









    Results (68 votes), past polls