Actions, resources, and condition keys for Amazon RDS Data API - AWS Identity and Access Management

Actions, resources, and condition keys for Amazon RDS Data API


This page is moving to a new location on November 16, 2020. Please update your bookmark to use the new page at

Amazon RDS Data API (service prefix: rds-data) provides the following service-specific resources, actions, and condition context keys for use in IAM permission policies.


Actions defined by Amazon RDS Data API

You can specify the following actions in the Action element of an IAM policy statement. Use policies to grant permissions to perform an operation in AWS. When you use an action in a policy, you usually allow or deny access to the API operation or CLI command with the same name. However, in some cases, a single action controls access to more than one operation. Alternatively, some operations require several different actions.

The Resource types column indicates whether each action supports resource-level permissions. If there is no value for this column, you must specify all resources ("*") in the Resource element of your policy statement. If the column includes a resource type, then you can specify an ARN of that type in a statement with that action. Required resources are indicated in the table with an asterisk (*). If you specify a resource-level permission ARN in a statement using this action, then it must be of this type. Some actions support multiple resource types. If the resource type is optional (not indicated as required), then you can choose to use one but not the other.

For details about the columns in the following table, see The actions table.

Actions Description Access level Resource types (*required) Condition keys Dependent actions
BatchExecuteStatement Runs a batch SQL statement over an array of data. Write
BeginTransaction Starts a SQL transaction. Write
CommitTransaction Ends a SQL transaction started with the BeginTransaction operation and commits the changes. Write


ExecuteSql Runs one or more SQL statements. This operation is deprecated. Use the BatchExecuteStatement or ExecuteStatement operation. Write
ExecuteStatement Runs a SQL statement against a database. Write
RollbackTransaction Performs a rollback of a transaction. Rolling back a transaction cancels its changes. Write


Resource types defined by Amazon RDS Data API

Amazon RDS Data API does not support specifying a resource ARN in the Resource element of an IAM policy statement. To allow access to Amazon RDS Data API, specify “Resource”: “*” in your policy.

Condition keys for Amazon RDS Data API

RDS Data API has no service-specific context keys that can be used in the Condition element of policy statements. For the list of the global context keys that are available to all services, see Available keys for conditions.