IAM role that have permission to unload only one schema in redshift

0

I want to create an IAM role that have permission to unload only one schema in redshift, is it achievable?

已提问 1 年前599 查看次数
1 回答
0

It is not possible to create an IAM role with permissions specific to a single schema in Amazon Redshift because IAM roles are used to manage permissions for AWS services, and Redshift uses its own internal permission management system for granting access to its objects (databases, schemas, tables, etc.).

To achieve what you're looking for, you should create a new Redshift user with limited permissions and then create a temporary IAM role or credentials that the user can assume to access the necessary S3 bucket for the UNLOAD operation.

profile picture
专家
已回答 1 年前

您未登录。 登录 发布回答。

一个好的回答可以清楚地解答问题和提供建设性反馈,并能促进提问者的职业发展。

回答问题的准则