如何授予用户对Athena只读权限

0

【以下的问题经过翻译处理】我的理解是，IAM “athena:StartQueryExecution”是必需的，才能在Athena中运行SQL查询。然而，这样用户就可以执行“INSERT INTO”语句。

是否有一种方法限制对Athena的访问权限，并只允许读取查询？

Topics

Tags

Language

中文 (简体)

EXPERT

rePost Polyglot

asked 6 months ago20 views

1 Answer

Newest
Most votes
Most comments

Are these answers helpful? Upvote the correct answer to help the community benefit from your knowledge.

0

【以下的回答经过翻译处理】如果你使用Lake Formation来授予Athena用户或角色访问权限，那么是可以做到的。当您授予访问表的权限时，只需授予SELECT权限即可。

EXPERT

rePost Polyglot

answered 6 months ago

Relevant content

多网络接口，多ip地址配置路由策略，从那个公网ip进入就从对应的ip出去。
rePost-User-8489725
asked a year ago
sagemaker美国人口普查数据在中国宁夏区下载提示拒绝访问
LiuChuang
asked a year ago
怎样通过CloudFormation来给DocumentDB创建一些表和索引(how to create some table and index in DocumentDB by CloudFormation）
Accepted Answer
Dgk
asked 10 months ago
如何讓 IAM 使用者只看的到自己建立的資源 ( How to allow IAM users to only see resources they have created.)
Accepted Answer
kerokero
asked 2 months ago
How do I resolve the "HIVE_CANNOT_OPEN_SPLIT" Athena query error?
AWS OFFICIALUpdated 4 months ago
How do use IAM to restrict access to Athena resources?
AWS OFFICIALUpdated 3 months ago
How can I use my IAM role credentials or switch to another IAM role when connecting to Athena using the JDBC driver?
AWS OFFICIALUpdated a year ago
How do I change my Athena engine version?
AWS OFFICIALUpdated 4 months ago
Migrating Glue Data Catalog tables to use Apache Iceberg open table format using Athena
EXPERT
Hamzah Chaudhry
published a month ago
Generative AI with Amazon Bedrock and Amazon Athena
EXPERT
Greg Vinton
published 6 months ago