Guest User

Untitled

a guest
Mar 8th, 2018
94
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.15 KB | None | 0 0
  1. ## I have the followind definitions
  2. Exec {
  3. path => "/bin"
  4. }
  5.  
  6. define database($admin, $user) {
  7. db_create { $title : }
  8. db_grant { "$admin@$title" :
  9. db => $title,
  10. user => $admin,
  11. grant => ALL,
  12. require => [ Db_user[$admin], Db_create[$title] ]
  13. }
  14. db_grant { "$user@$title" :
  15. db => $title,
  16. user => $user,
  17. grant => DCL,
  18. require => [ Db_user[$user], Db_create[$title] ]
  19. }
  20. }
  21.  
  22. define db_create {
  23. exec { "echo $title": }
  24. }
  25.  
  26. define db_grant($db, $user, $grant) {
  27. exec { "echo $title": }
  28. }
  29.  
  30. define db_user($password) {
  31. exec { "echo $title": }
  32. }
  33.  
  34. ##Now I can use the following to create a database and grant users access:
  35.  
  36. database { "testdb":
  37. admin => "dbadmin",
  38. user => "dbuser"
  39. }
  40.  
  41. db_user { "dbadmin": password => "foo" }
  42. db_user { "dbuser": password => "foo" }
  43.  
  44.  
  45. ##But what I really want to do is:
  46.  
  47. database { "testdb":
  48. admin => "dbadmin",
  49. user => [ "dbuser1", "dbuser2", "dbuser3" ]
  50. }
  51.  
  52. db_user { "dbadmin": password => "foo" }
  53. db_user { "dbuser1": password => "foo" }
  54. db_user { "dbuser2": password => "foo" }
  55. db_user { "dbuser3": password => "foo" }
Add Comment
Please, Sign In to add comment