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

aws_lakeformation_permissions column level permission is not working #19409

Closed
surendarkaniops opened this issue May 17, 2021 · 3 comments · Fixed by #19817
Closed

aws_lakeformation_permissions column level permission is not working #19409

surendarkaniops opened this issue May 17, 2021 · 3 comments · Fixed by #19817
Assignees
Labels
service/lakeformation Issues and PRs that pertain to the lakeformation service.
Milestone

Comments

@surendarkaniops
Copy link

aws_lakeformation_permissions column level permission is not working even i tried wild card value.

resource "aws_lakeformation_permissions" "grantpermission-columns-users_wildcard" {
count = var.columns_wildcard ? 1 : 0
principal = var.user_principal
permissions = var.user_permissions_coloumn
table_with_columns {
database_name = var.user_database
name = var.user_database_table
excluded_column_names = var.excluded_column_names
wildcard = var.columns_wildcard
}
}

user_permissions_table = ["CREATE_TABLE", "ALTER", "DROP"]
user_permissions_coloumn = ["CREATE_TABLE", "ALTER", "DROP"]
columns_wildcard = true
excluded_column_names = ["policyid"] ## must and only when columns_wildcard arguement is enabled
user_principal = "arn:aws:iam:::role/LakeFormationAnalyst"
athena_query_savings = "supertest-dataprocessed"
crawler_data_source = "supertest-datasource"

@ghost ghost added the service/lakeformation Issues and PRs that pertain to the lakeformation service. label May 17, 2021
@github-actions github-actions bot added the needs-triage Waiting for first response or review from a maintainer. label May 17, 2021
@YakDriver
Copy link
Member

@surendarkaniops You cannot apply CREATE_TABLE permission this way as it is not a columnar permission. Besides that issue, I have verified that your test case works with #19817. I added a new acceptance test called TestAccAWSLakeFormation_serial/TableWithColumnsPermissions/columnWildcardExcludedColumnsPermissions specifically to test that wildcard + excluded column names works.

@YakDriver YakDriver removed the needs-triage Waiting for first response or review from a maintainer. label Jun 16, 2021
@YakDriver YakDriver self-assigned this Jun 16, 2021
@github-actions github-actions bot added this to the v3.46.0 milestone Jun 17, 2021
@github-actions
Copy link

This functionality has been released in v3.46.0 of the Terraform AWS Provider. Please see the Terraform documentation on provider versioning or reach out if you need any assistance upgrading.

For further feature requests or bug reports with this functionality, please create a new GitHub issue following the template. Thank you!

@github-actions
Copy link

I'm going to lock this issue because it has been closed for 30 days ⏳. This helps our maintainers find and focus on the active issues.
If you have found a problem that seems similar to this, please open a new issue and complete the issue template so we can capture all the details necessary to investigate further.

@github-actions github-actions bot locked as resolved and limited conversation to collaborators Jul 18, 2021
Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
service/lakeformation Issues and PRs that pertain to the lakeformation service.
Projects
None yet
Development

Successfully merging a pull request may close this issue.

2 participants