Defined Type: postgresql::server::database_grant

Defined in:
manifests/server/database_grant.pp

Summary

Manage a database grant.

Overview

Parameters:

  • privilege (Any)

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

  • db (Any)

    Specifies the database to which you are granting access.

  • role (Any)

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

  • ensure (Any) (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 (Any) (defaults to: undef)

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

  • psql_user (Any) (defaults to: undef)

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

  • connect_settings (Any) (defaults to: undef)

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



10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
# File 'manifests/server/database_grant.pp', line 10

define postgresql::server::database_grant (
  $privilege,
  $db,
  $role,
  $ensure           = undef,
  $psql_db          = undef,
  $psql_user        = undef,
  $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,
  }
}