Custom policies can be created to supplement the system policies of RDS.
You can create custom policies in either of the following two ways:
For details, see Creating a Custom Policy. The following section contains examples of common RDS custom policies.
{ "Version": "1.1", "Statement": [{ "Effect": "Allow", "Action": ["rds:instance:create"] }] }
A policy with only "Deny" permissions must be used in conjunction with other policies to take effect. If the permissions assigned to a user include both "Allow" and "Deny", the "Deny" permissions take precedence over the "Allow" permissions.
The following method can be used if you need to assign permissions of the RDS FullAccess policy to a user but you want to prevent the user from deleting RDS DB instances. Create a custom policy for denying RDS DB instance deletion, and attach both policies to the group the user belongs to. Then, the user can perform all operations on RDS DB instances except deleting RDS DB instances. The following is an example deny policy:
{ "Version": "1.1", "Statement": [{ "Action": ["rds:instance:delete"], "Effect": "Deny" }] }