Official postgresql module from puppetlabs allow granting privileges on specific database.
postgresql::database_grant{'grant to myuser':
privilege => 'CREATE',
db => 'app_production',
role => 'myuser',
}
this would execute:
GRANT ${privilege} ON database ${db} TO ${role};
However I'd like to execute query on global permissions for given user:
ALTER role myuser login createdb;
Is there a way how to do this? Or should I use different puppet module for PostgreSQL?