locked
Connecting to oracle DB RRS feed

  • Question

  • Hi Team,

    I'm able to connect to oracle DB with Powershell but I'm hardcoding and giving the Oracle DB password in the connection string. Is there any way I can connect without mentioning the Password?

     $connectionString = "Data Source=XYZ;User Id=ABC;Password=ABC1234;Integrated Security=no"

    I feel there are three challenges,

    1) During deployment for each environment, password need to be manually changed

    2) If the DB password is changed, then someone need to open this script and manually change it

    3) Security violation

    Please suggest!!

    Cheers

    Jim

    Wednesday, March 16, 2016 1:46 PM

Answers

  • Configure Oracle to use Kerberos security.

    Post in Oracle forum for instructions.


    \_(ツ)_/

    • Proposed as answer by Wendy Jiang Thursday, March 24, 2016 2:58 AM
    • Marked as answer by Yan Li_ Friday, March 25, 2016 7:15 AM
    Wednesday, March 16, 2016 2:02 PM