Did you know that, amongst others, you can easily make custom facts from any data in your oracle database with the ora_config puppet module?
https://forge.puppet.com/modules/enterprisemodules/ora_config The module will take care of securely handling passwords for you. On Friday, 22 January 2021 at 13:23:23 UTC+1 LinuxDan wrote: > Have you considered “orapwd” ? > https://docs.oracle.com/database/121/ADMIN/dba.htm#ADMIN12478 > _______________________________________________________ > *Dan White : [email protected]* > “Sometimes I think the surest sign that intelligent life exists elsewhere > in the universe is that none of it has tried to contact us.” > Bill Waterson (Calvin & Hobbes) > > On Jan 22, 2021, at 3:02 AM, Vinay Korrapati <[email protected]> wrote: > > > puppet enterprise : 2019.8.1 > Oracle: 12c > > On Friday, January 22, 2021 at 1:10:42 PM UTC+5:30 Vinay Korrapati wrote: > >> Hi Team, >> >> Can we pass the credentials in custom facts in secure way? >> >> *Use case : *I have to write a fact which , executes a Query on Oracle >> DB's and returns the output. >> >> To execute the query it requires the credentials ($oralogin). >> Eg: >> >> $OracleUserName="username" >> $OraclePassword="password" >> >> $OraLogin = "$OracleUserName/$OraclePassword@" + $oraInstance + " as sysdba" >> >> $Query | sqlplus -silent $OraLogin >> >> Any thoughts/suggestions to pass the credentials in secure way ? >> >> Regards >> Vinay >> > > -- > You received this message because you are subscribed to the Google Groups > "Puppet Users" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To view this discussion on the web visit > https://groups.google.com/d/msgid/puppet-users/149bea7f-2cf8-4e38-8fd6-225b34e90912n%40googlegroups.com > > <https://groups.google.com/d/msgid/puppet-users/149bea7f-2cf8-4e38-8fd6-225b34e90912n%40googlegroups.com?utm_medium=email&utm_source=footer> > . > > > -- You received this message because you are subscribed to the Google Groups "Puppet Users" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/puppet-users/aca962dd-cee5-4df2-b118-c1c8fd1c80aen%40googlegroups.com.
