Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Cannot specify a group as owner in redshift_default_privileges #142

Open
dkravetz opened this issue Nov 29, 2024 · 0 comments
Open

Cannot specify a group as owner in redshift_default_privileges #142

dkravetz opened this issue Nov 29, 2024 · 0 comments

Comments

@dkravetz
Copy link

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!

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant