How do I protect my password when using SQLPLUS from a DOS command line
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: How do I protect my password when using SQLPLUS from a DOS command line

  1. #1
    Join Date
    Jan 2012
    Posts
    2

    How do I protect my password when using SQLPLUS from a DOS command line

    I have Windows 2008R2 server. I need to run a script to extract data into a CSV file.

    I don't want to put the account password in the script.

    Does anybody have a recommendation on how to protect the password so it is not in clear txt in the script that runs SQLPLUS?

    Thanks
    Share on Google+

  2. #2
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,554
    Quote Originally Posted by LarryG View Post
    I have Windows 2008R2 server. I need to run a script to extract data into a CSV file.

    I don't want to put the account password in the script.

    Does anybody have a recommendation on how to protect the password so it is not in clear txt in the script that runs SQLPLUS?

    Thanks
    An Operating System authenticated account should do it. http://www.oracle-base.com/articles/...entication.php
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
    Share on Google+

  3. #3
    Join Date
    Apr 2011
    Location
    Dallas, TX
    Posts
    17
    Duplicate thread. Continued here: http://www.dbasupport.com/forums/showthread.php?t=62415

    Please only ask your question one time
    Share on Google+

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width