IAM Authentication is not available for RDS Instances engines

Question

Hi Everyone, hope you all are doing great 😁 !!

I became aware that not all RDS instances engines and or versions support IAM authentication. After some search I did not find any reference related to this, neither in AWS nor any IaC tool. I did some trial and error in AWS website and came to this conclusion:

Amazon Aurora : All Versions support

MySQL : Versions >= 8

MariaDB : Version >= 10.6

PostGre : Version != 13.7-R1

Oracle : Not Available

MS SQL : Not Available

Can someone confirm what I found or indicate some official source related to it?

For some context, I work on an Open Source Project Named [KICS](https://github.com/Checkmarx/kics/). that checks for vulnerabilities and misconfiguration in Infrasture as Code files like Terraform and CloudFormation. Feel free to check out and try it it's free! 🚀

Accepted Answer

You can find information on IAM Authentication for RDS here: https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/Concepts.RDSFeaturesRegionsDBEngines.grids.html#Concepts.RDS_Fea_Regions_DB-eng.Feature.IamDatabaseAuthentication and for Aurora here: https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/UsingWithRDS.IAMDBAuth.html#UsingWithRDS.IAMDBAuth.Availability

There is some nuance; i.e. db.t2.small Aurora instances do not support IAM authentication.

Answer

Refer this link for details on supported RDS types for IAM based authentication.

https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/Concepts.RDS_Fea_Regions_DB-eng.Feature.IamDatabaseAuthentication.html

![Enter image description here](/media/postImages/original/IMpw_G-8aiTKWs8Z51cfVGEA)

IAM Authentication is not available for RDS Instances engines

相關內容