How to decrypt the password using Powershell

• SQL_Hunt

  SSC-Dedicated

  Points: 33518

  More actions

  March 4, 2016 at 4:33 pm

  #309176

  Hello,

  I saved the password to a file. But when I try to read it , I do not get the actual one. How to decypher the pswd. Please suggest.

  Read-Host "Enter Password" -AsSecureString | ConvertFrom-SecureString | Out-File "C:\Temp\Password.txt"

  $pass = Get-Content "C:\Temp\Password.txt" | ConvertTo-SecureString

  $pass

  Password: System.Security.SecureString

  Do I need to again any of the PS function to convert to the actual value? Or, do I only need to use that as "Credential"?

  $User = "abcd"

  $File = "C:\Temp\Password.txt"

  $MyCredential=New-Object -TypeName System.Management.Automation.PSCredential ` -ArgumentList $User, (Get-Content $File | ConvertTo-SecureString)

  Thanks.

• SQL_Hunt

  SSC-Dedicated

  Points: 33518

  More actions

  March 4, 2016 at 5:29 pm

  #1863301

  Even could not able to pass it properly to the connection string using $bytes and username too.

  $password = read-host -prompt "Enter your Password"

  $secure = ConvertTo-SecureString $password -force -asPlainText

  $secure

  $bytes = ConvertFrom-SecureString $secure

  $bytes

  Thanks.

• SQL_Hunt

  SSC-Dedicated

  Points: 33518

  More actions

  March 4, 2016 at 5:33 pm

  #1863302

  Using this encrypted pswd, failing to connect to Oracle Instance..

  $password = read-host -prompt "Enter your Password"

  $secure = ConvertTo-SecureString $password -force -asPlainText

  $secure

  $bytes = ConvertFrom-SecureString $secure

  $bytes

  $username = "usr"

  $tnsalias = "TNS.ORA"

  $script = Get-content "D:\Powershell_Output_test\Script\Oracle_Script\select.sql"

  $script

  $outputfile = "D:\Powershell_Output_test\output_Oracle\sql-output.txt"

  $script | sqlplus -silent $username/$bytes@$tnsalias $script | Out-File $outputfile

  Thanks.

• Perry Whittle

  SSC Guru

  Points: 234040

  More actions

  March 6, 2016 at 5:37 am

  #1863368

  SQL-DBA-01 (3/4/2016)

  ---

  Even could not able to pass it properly to the connection string using $bytes and username too.

  $password = read-host -prompt "Enter your Password"

  $secure = ConvertTo-SecureString $password -force -asPlainText

  $secure

  $bytes = ConvertFrom-SecureString $secure

  $bytes

  Generally use

  $password = read-host -prompt "Enter your Password" -AsSecureString

  To decrypt the secure string you would use

  $BSTR = `

  [System.Runtime.InteropServices.Marshal]::SecureStringToBSTR($password)

  $PlainPassword = [System.Runtime.InteropServices.Marshal]::PtrToStringAuto($BSTR)

  Write-Host "Password is: $($PlainPassword)"

  -----------------------------------------------------------------------------------------------------------

  "Ya can't make an omelette without breaking just a few eggs"

• SQL_Hunt

  SSC-Dedicated

  Points: 33518

  More actions

  March 7, 2016 at 9:19 am

  #1863494

  Many thanks Perry. It is working.

  Thanks.