aws-cloudformation / aws-cloudformation/cloudformation-coverage-roadmap
AWS::RDS::DBInstance needs property to initialize master user roles to enable IAM authentication
- Dominant language
- No language data
- Stars
- 1.1k
- Forks
- 62
- PR merge metrics
- No merged PRs in 30d
Description
1. Title
AWS::RDS::DBInstance-InitialMasterUserRoles
2. Scope of request
New resource attribute
3. Expected behavior
To use RDS IAM authentication, one has to `GRANT` the `rds_iam` role to the RDS master user. To automate this using CloudFormation, one has to write a VPC lambda for the sole purpose of logging into the RDS instance using the master password, and running
```
GRANT rds_iam TO masteruser
```
This is a lot of complexity for such a simple operation. It would be great if there was a way to assign the initial master roles in CloudFormation, so that one could do:
```
FooDB:
Type: AWS::RDS::DBInstance
Properties:
...
InitialMasterUserRoles:
- rds_iam
...
```
5. Links
https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/UsingWithRDS.IAMDBAuth.html
6. Category tag
DB
Contributor guide
Research direction
Start with the AWS RDS IAM database authentication documentation linked in the issue and the AWS::RDS::DBInstance property example. Determine how InitialMasterUserRoles should represent the requested roles and how it should interact with the master user. Done means CloudFormation can configure the initial rds_iam role without a separate VPC Lambda.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- aws
- Domain
- authentication, cloud, database
- Issue type
- Feature
- Difficulty
- 5/5
- Estimated time
- Over a week
- Activity status
- Stale
- Clarity
- Clearly specified
- Newbie friendliness
- 30/100