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. 01-11-2012, 04:27 PM #1
    LarryG
    LarryG is offline Junior Member
    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
  2. 01-11-2012, 06:43 PM #2
    PAVB's Avatar
    PAVB
    PAVB is offline Senior Advisor
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,555
    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.
  3. 01-12-2012, 06:07 AM #3
    Steve R Jones
    Steve R Jones is offline Administrator
    Join Date
    Apr 2011
    Location
    Largo, FL.
    Posts
    42
    Duplicate thread. Continued here: http://www.dbasupport.com/forums/showthread.php?t=62415

    Please only ask your question one time
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules

Click Here to Expand Forum to Full Width