_temp AWS lake formation blueprint pipeline tables appears to IAM user in athena editor although I didn't give this user permission on them
_temp lake formation blueprint pipeline tables appears to IAM user in Athena editor, although I didn't give this user permission on them below the policy granted to this IAM user,also in lake formation permsissions ,I didnt give this user any permissions on _temp tables:
{ "Version": "2012-10-17", "Statement": [ { "Sid": "Stmt1652364721496", "Action": "athena:BatchGetNamedQuery", "athena:BatchGetQueryExecution", "athena:GetDataCatalog", "athena:GetDatabase", "athena:GetNamedQuery", "athena:GetPreparedStatement", "athena:GetQueryExecution", "athena:GetQueryResults", "athena:GetQueryResultsStream", "athena:GetTableMetadata", "athena:GetWorkGroup", "athena:ListDataCatalogs", "athena:ListDatabases", "athena:ListEngineVersions", "athena:ListNamedQueries", "athena:ListPreparedStatements", "athena:ListQueryExecutions", "athena:ListTableMetadata", "athena:ListTagsForResource", "athena:ListWorkGroups", "athena:StartQueryExecution", "athena:StopQueryExecution" , "Effect": "Allow", "Resource": "" }, { "Effect": "Allow", "Action": "glue:GetDatabase", "glue:GetDatabases", "glue:BatchDeleteTable", "glue:GetTable", "glue:GetTables", "glue:GetPartition", "glue:GetPartitions", "glue:BatchGetPartition" , "Resource": [ "" ] }, { "Sid": "Stmt1652365282568", "Action": "s3:", "Effect": "Allow", "Resource": [ "arn:aws:s3:::queryresults-all", "arn:aws:s3:::queryresults-all/" ] }, { "Effect": "Allow", "Action": "lakeformation:GetDataAccess" , "Resource": "*" } ] }
solved by changing the Lake formation security settings https://docs.aws.amazon.com/lake-formation/latest/dg/getting-started-setup.html#setup-change-cat-settings
Relevant questions
Error Running Glue Crawler
Accepted Answerasked 2 years agoLake formation blueprint job error :org.postgresql.util.PSQLException: ERROR: permission denied for table tmp_
asked 2 days agoAthena query: Insufficient Lake Formation permission(s): Illegal permission combination
asked 4 months agoAWS Lake Formation: (AccessDeniedException) when calling the GetTable operation: Insufficient Lake Formation permission(s) on table
asked 2 months agoRedshift Spectrum Access to Lake Formation
Accepted Answerasked 3 years agoAre you able to hide tables in a database using Lake Formation Tagging
asked a month ago_temp AWS lake formation blueprint pipeline tables appears to IAM user in athena editor although I didn't give this user permission on them
asked 8 days agoIs it possible to specify DB snapshot in AWS Lake Formation?
Accepted Answerasked a year agoHow to grant users read only permission to Athena
Accepted Answerasked 2 years agoUsing Athena to query AWS Lake Formation database
asked 25 days ago