Skip to Main Content
Forums

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Connecting to oracle DB from Powershell

3200600Mar 17 2016 — edited Mar 18 2016

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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 15 2016
Added on Mar 17 2016
#general-database-discussions
8 comments
8,107 views