IAM users can't see Athena tables

user_145357 0
Viewed 1450

My IAM users can't see the Athena tables I've created a long time ago using the root account.

Their group has the following permissions:

  • AmazonS3FullAccess
  • AmazonAthenaFullAccess

They only see the sampledb databases, which is unfortunate, because they need the one we actually use. The documentation is not clear on how to make the databases accessible to everyone. How do I achieve that?

amazon-iam amazon-athena amazon-web-services
2 Answers

Your permissions are correct.

Athena's context is not currently shared across regions. Ensure that the users are viewing Athena from the same region as the root account. When they login to AWS, they may be initially placed in another region.

user_96880280

You need Glue permissions, Glue is the service in charge of manage Databases and Tables in AWS

user_33422090
Related