Defined Type: postgresql::server::database_grant

Defined in:

manifests/server/database_grant.pp

Summary

Manage a database grant.

Overview

Parameters:

• privilege (Enum['ALL', 'CREATE', 'CONNECT', 'TEMPORARY', 'TEMP', 'all', 'create', 'connect', 'temporary', 'temp']) —

  Specifies comma-separated list of privileges to grant. Valid options: ‘ALL’, ‘CREATE’, ‘CONNECT’, ‘TEMPORARY’, ‘TEMP’.

• db (String[1]) —

  Specifies the database to which you are granting access.

• role (String[1]) —

  Specifies the role or user whom you are granting access to.

• ensure (Optional[Enum['present', 'absent']]) (defaults to: undef) —

  Specifies whether to grant or revoke the privilege. Revoke or ‘absent’ works only in PostgreSQL version 9.1.24 or later.

• psql_db (Optional[String[1]]) (defaults to: undef) —

  Defines the database to execute the grant against. This should not ordinarily be changed from the default

• psql_user (Optional[String[1]]) (defaults to: undef) —

  Specifies the OS user for running psql. Default value: The default user for the module, usually ‘postgres’.

• connect_settings (Optional[Hash]) (defaults to: undef) —

  Specifies a hash of environment variables used when connecting to a remote server.

# File 'manifests/server/database_grant.pp', line 10

define postgresql::server::database_grant (
  Enum['ALL', 'CREATE', 'CONNECT', 'TEMPORARY', 'TEMP', 'all', 'create', 'connect', 'temporary', 'temp'] $privilege,
  String[1]                           $db,
  String[1]                           $role,
  Optional[Enum['present', 'absent']] $ensure           = undef,
  Optional[String[1]]                 $psql_db          = undef,
  Optional[String[1]]                 $psql_user        = undef,
  Optional[Hash]                      $connect_settings = undef,
) {
  postgresql::server::grant { "database:${name}":
    ensure           => $ensure,
    role             => $role,
    db               => $db,
    privilege        => $privilege,
    object_type      => 'DATABASE',
    object_name      => $db,
    psql_db          => $psql_db,
    psql_user        => $psql_user,
    connect_settings => $connect_settings,
  }
}