Ask Your Question
0

How to connect and change a oracle database accounts {eg sys/system account } password through puppet ?

asked 2017-12-21 00:11:59 -0500

shajics gravatar image

I have requirement to change database account passwords through puppet, Just would like to know if anyone has already done that or if you can point me to any of the forge modules that can used in this regard.

Thanks again for your time and help.

edit retag flag offensive close merge delete

1 Answer

Sort by ยป oldest newest most voted
0

answered 2017-12-21 08:30:51 -0500

DarylW gravatar image

Depends on the database! Have a look around forge.puppet.com and see if anything works for you... with MySQLfor example

https://forge.puppet.com/puppetlabs/m...

Create a database

To create a database with a user and some assigned privileges:

 mysql::db { 'mydb':
  user     => 'myuser',
  password => 'mypass',
  host     => 'localhost',
  grant    => ['SELECT', 'UPDATE'],
}

https://forge.puppet.com/puppetlabs/m...

Specify passwords

In addition to passing passwords as plain text, you can input them as hashes. For example:

 mysql::db { 'mydb':
  user     => 'myuser',
  password => '*6C8989366EAF75BB670AD8EA7A7FC1176A95CEF4',
  host     => 'localhost',
  grant    => ['SELECT', 'UPDATE'],
}

https://forge.puppet.com/puppetlabs/m...

edit flag offensive delete link more

Your Answer

Please start posting anonymously - your entry will be published after you log in or create a new account.

Add Answer

Question Tools

Stats

Asked: 2017-12-21 00:11:59 -0500

Seen: 5,865 times

Last updated: Dec 21 '17