postgresql_default_privileges.html.markdown

layout	page_title	sidebar_current	description
postgresql	PostgreSQL: postgresql_default_privileges	docs-postgresql-resource-postgresql_default_privileges	Creates and manages default privileges given to a user for a database schema.

postgresql_default_privileges

The postgresql_default_privileges resource creates and manages default privileges given to a user for a database schema.

~> Note: This resource needs Postgresql version 9 or above.

Usage

resource "postgresql_default_privileges" "read_only_tables" {
  role     = "test_role"
  database = "test_db"
  schema   = "public"

  owner       = "db_owner"
  object_type = "table"
  privileges  = ["SELECT"]
}

Argument Reference

• role - (Required) The name of the role to which grant default privileges on.
• database - (Required) The database to grant default privileges for this role.
• owner - (Required) Role for which apply default privileges (You can change default privileges only for objects that will be created by yourself or by roles that you are a member of).
• schema - (Required) The database schema to set default privileges for this role.
• object_type - (Required) The PostgreSQL object type to set the default privileges on (one of: table, sequence, function, type).
• privileges - (Required) The list of privileges to apply as default privileges.