Skip to content
This repository was archived by the owner on Jan 17, 2025. It is now read-only.
This repository was archived by the owner on Jan 17, 2025. It is now read-only.

Cannot specify a group as owner in redshift_default_privileges #142

@dkravetz

Description

@dkravetz

Good day!

I have the following resources

resource "redshift_default_privileges" "rbac_redshift_engineers_objects" {
  group       = redshift_group.read_only_group.name
  owner       = redshift_group.rbac_redshift_engineers.name
  object_type = "table"
  privileges  = ["select", "rule", "trigger"]
  schema      = "public"
}

The specified groups exist, however, I receive the error message

Error: pq: user "rbac_redshift_engineers" does not exist

From my understanding of the official docs https://docs.aws.amazon.com/redshift/latest/dg/r_ALTER_DEFAULT_PRIVILEGES.html it seems like in the examples, this should be possible:

The following example grants INSERT privilege to the sales_admin user group for all new tables and views that you create in the sales schema.

`alter default privileges in schema sales grant insert on tables to group sales_admin; `

Please advise what could be done, thank you!

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions