Attach RDS access policy for IAM user

Create Policies for access database

1. Got to Identity and Access Management(IAM) console
2. Select Policies.
3. Click on Select Policy
4. On Specify permissions page select JSON.
5. Add following permission for view and access DB.

{
 "Version": "2012-10-17",
 "Statement": [
  { 
   "Sid": "RDSViewAccess",
   "Effect": "Allow",
   "Action": [
    "rds:DescribeDBInstances",
    "rds:DescribeDBClusters",
    "rds:DescribeGlobalClusters"
   ],
   "Resource": [
    "arn:aws:rds:us-east-1:AccountID:db:*",
    "arn:aws:rds:us-east-1:*:cluster:*",
    "arn:aws:rds::AccountID:global-cluster:*"
   ]
  },
  { 
   "Sid": "RDSPermission",
   "Effect": "Allow",
   "Action": [
    "rds:*"
   ],
   "Resource": [
    "arn:aws:rds:us-east-1:AccountId:cluster:postgres-database-dev-0514"
   ]
  }
 ]
}

1. Click on next.
2. Give policy details: Name and Description.
3. Click on create permission.

Attach Policy to IAM User for RDS access

1. Click on users.
2. Select user for assign permission.
3. Click on Add permissions.
4. From permissions options select Attach policies directly.
5. Search Policy as given in above step 8.
6. Click next.
7. Click on Add permissions

Login with IAM user and verify RDS access. Now you can able to access specific RDS as mentioned in policy.