View a markdown version of this page

Actions, resources, and condition keys for Amazon RDS Data API - Service Authorization Reference

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

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

References:

API operations defined by Amazon RDS Data API

The following table maps API operations to the IAM actions they authorize. Only condition keys that have static values for the given API and action are listed; for the full set of condition keys supported by each action, see the Actions table.

Operation IAM action Condition key Possible value(s) Access level

BatchExecuteStatement

rds-data:BatchExecuteStatement

Write

BeginTransaction

rds-data:BeginTransaction

Write

CommitTransaction

rds-data:CommitTransaction

Write

ExecuteSql

rds-data:ExecuteSql

Write

ExecuteStatement

rds-data:ExecuteStatement

Write

RollbackTransaction

rds-data:RollbackTransaction

Write

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.

Actions Description Resource types (*required) Condition keys Access level

BatchExecuteStatement

Grants permission to run a batch SQL statement over an array of data

cluster*

aws:ResourceTag/${TagKey}

aws:TagKeys

Write

BeginTransaction

Grants permission to start a SQL transaction

cluster*

aws:ResourceTag/${TagKey}

aws:TagKeys

Write

CommitTransaction

Grants permission to end a SQL transaction started with the BeginTransaction operation and commits the changes

cluster*

aws:ResourceTag/${TagKey}

aws:TagKeys

Write

ExecuteSql

Grants permission to run one or more SQL statements. This operation is deprecated. Use the BatchExecuteStatement or ExecuteStatement operation

cluster*

aws:ResourceTag/${TagKey}

aws:TagKeys

Write

ExecuteStatement

Grants permission to run a SQL statement against a database

cluster*

aws:ResourceTag/${TagKey}

aws:TagKeys

Write

RollbackTransaction

Grants permission to perform a rollback of a transaction. Rolling back a transaction cancels its changes

cluster*

aws:ResourceTag/${TagKey}

aws:TagKeys

Write

Resource types defined by Amazon RDS Data API

The following resource types are defined by this service and can be used in the Resource element of IAM permission policy statements.

Resource types ARN Condition keys

cluster

arn:${Partition}:rds:${Region}:${Account}:cluster:${DbClusterInstanceName}

aws:ResourceTag/${TagKey}

aws:TagKeys

Condition keys for Amazon RDS Data API

Amazon RDS Data API defines the following condition keys that can be used in the Condition element of an IAM policy.

Condition keys Description Type

aws:ResourceTag/${TagKey}

Filters access by the tags associated with the resource

String

aws:TagKeys

Filters access by the tag keys associated with the resource

ArrayOfString