Creating data source with database name without username name password from RDS proxy

Question

I have created multiple databases, each database has its username and password. A secret is created in secretsmanager to store username and password for each database. Also RDS proxy is associated with the secrets and IAM role which has the permission to access the secrets.

Currently in my java spring boot microservice I am creating data source object with username, password and database name.

Is there any way to connect to a particular database by just providing the database name without the username and password ?

Answer

Hello.

> Is there any way to connect to a particular database by just providing the database name without the username and password ?

Using IAM authentication eliminates the need for passwords.  
However, you must instead issue temporary credentials and use them to connect to the database.  
https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/UsingWithRDS.IAMDBAuth.html

Additionally, IAM authentication has limitations, so you may need to be careful when using it depending on the application.  
https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/UsingWithRDS.IAMDBAuth.html#UsingWithRDS.IAMDBAuth.Limitations

Creating data source with database name without username name password from RDS proxy

Relevant content