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 : d_e_...@icloud.com* > “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 <vina...@gmail.com> 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 puppet-users...@googlegroups.com. > 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 puppet-users+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/puppet-users/aca962dd-cee5-4df2-b118-c1c8fd1c80aen%40googlegroups.com.
