IAM Policy to restrict read/write data into RDS

Hello,

we are establishing permission sets and associating these policies to the permission sets. We use AD authentication by SSO groups. I was looking at restricting policy , similar to traditional databases, as in DataReadUser, DataWriteUser, for the tables in RDS. This is different from RDSRead which is not related to RDS tables. What options for setting these policies?

Topics

Database

Tags

Database RDS Custom for SQL Server

Language

English

Swee

asked a year ago525 views

1 Answer

Newest
Most votes
Most comments

Hi. Unfortunately IAM can not control actions for RDS tables.But you know, you will be able to control db user's access in tradional way(Create db user and grant access)

https://repost.aws/knowledge-center/duplicate-master-user-mysql

EXPERT

Hiroki Takahashi

answered a year ago

Relevant content

Permissions Boundaries and IAM Identity Center Permissions Sets
Accepted Answer
Will
asked 9 months ago
Why can't (multiple) user managed policies be added to an SSO Permission Set?
AWS-User-0730315
asked 3 years ago
Policy assignment using Permission set vs Identity and Resource
Accepted Answer
Lottie
asked 8 months ago
Customer Managed Policies (CMPs) attached to AWS SSO Permission Set
Arjun Goel
asked 10 months ago
How do I use IAM Identity Center permission sets?
AWS OFFICIALUpdated a year ago
What are the minimum IAM permissions needed to use VPC peering to set up communication between Lightsail and other AWS services?
AWS OFFICIALUpdated 5 months ago
How do I recreate a deleted IAM user or role with the same policies and permissions?
AWS OFFICIALUpdated 13 days ago
How do I use the IAM policy simulator to test IAM policies and permissions?
AWS OFFICIALUpdated a month ago
Why doesn't S3 respect the TLS settings in my IAM policy?
EXPERT
Brettski-AWS
published 2 years ago
Setting up AWS IAM Authentication with Amazon RDS Proxy for Aurora PostgreSQL
EXPERT
nareshrajaram
published a month ago