Actions, resources, and condition keys for Amazon SQL Workbench
Amazon SQL Workbench (service prefix: sqlworkbench) provides the following
service-specific operations, resources, actions, and condition keys for use in IAM permission
policies.
References:
-
Learn how to configure this service.
-
View a list of the API operations available for this service.
-
Learn how to secure this service and its resources by using IAM permission policies.
-
View the programmatic service authorization reference
for this service.
Topics
Actions defined by Amazon SQL Workbench
Amazon SQL Workbench has no API operations that can be used in the
Actions element of an IAM policy statement.
Permission-only actions for Amazon SQL Workbench
The following actions are defined by Amazon SQL Workbench but are not directly invocable through any API operation. They can only be used in IAM policy statements to grant or deny permissions.
| Actions | Description | Resource types (*required) | Condition keys | Access level |
|---|---|---|---|---|
Grants permission to associate connection to a chart |
Write |
|||
Grants permission to associate connection to a tab |
Write |
|||
Grants permission to associate notebook to a tab |
Write |
|||
Grants permission to associate query to a tab |
Write |
|||
Grants permission to delete folders on your account |
Write |
|||
Grants permission to get notebook cells content on your account |
Read |
|||
Grants permission to create SQLWorkbench account |
Write |
|||
Grants permission to create new saved chart on your account |
Write |
|||
Grants permission to create a new connection on your account |
Write |
|||
Grants permission to create folder on your account |
Write |
|||
Grants permission to create a new notebook on your account |
Write |
|||
Grants permission to create a notebook cell on your account |
Write |
|||
Grants permission to create a new notebook from a notebook version on your account |
Write |
|||
Grants permission to create a notebook version on your account |
Write |
|||
Grants permission to create a new saved query on your account |
Write |
|||
Grants permission to remove charts on your account |
Write |
|||
Grants permission to remove connections on your account |
Write |
|||
Grants permission to remove notebooks on your account |
Write |
|||
Grants permission to remove notebooks cells on your account |
Write |
|||
Grants permission to remove notebooks cells on your account |
Write |
|||
Grants permission to delete account-wide custom context |
Write |
|||
Grants permission to remove saved queries on your account |
Write |
|||
Grants permission to delete sql generation context |
Write |
|||
Grants permission to remove a tab on your account |
Write |
|||
Grants permission to execute a query in your redshift cluster |
Write |
|||
Grants permission to create a new notebook by duplicating an existing one on your account |
Write |
|||
Grants permission to export a notebook on your account |
Read |
|||
Grants permission to generate a new session on your account |
Write |
|||
Grants permission to get account info |
Read |
|||
Grants permission to get account settings |
Read |
|||
Grants permission to get database structure metadata for auto-completion |
Read |
|||
Grants permission to get database structure information for auto-completion |
Read |
|||
Grants permission to get charts on your account |
Read |
|||
Grants permission to get connections on your account |
Read |
|||
Grants permission to get notebook metadata on your account |
Read |
|||
Grants permission to get the content of a notebook version on your account |
Read |
|||
Grants permission to get account-wide custom context |
Read |
|||
Grants permission to get Q generative SQL maximum prompt quotas |
Read |
|||
Grants permission to get text to SQL recommendations |
Read |
|||
Grants permission to get the query execution history on your account |
Read |
|||
Grants permission to get saved query on your account |
Read |
|||
Grants permission to get the columns and data types inferred from a file |
Read |
|||
Grants permission to get sql generation context |
Read |
|||
Grants permission to get text to SQL recommendations |
Read |
|||
Grants permission to get user info |
Read |
|||
Grants permission to get workspace settings on your account |
Read |
|||
Grants permission to import a notebook on your account |
Write |
|||
Grants permission to list the connections on your account |
List |
|||
Grants permission to list databases of your redshift cluster |
List |
|||
Grants permission to list files and folders |
List |
|||
Grants permission to get notebook versions metadata on your account |
List |
|||
Grants permission to list the notebooks on your account |
List |
|||
Grants permission to list the query execution history on your account |
List |
|||
Grants permission to list redshift clusters on your account |
List |
|||
Grants permission to list sample databases |
Read |
|||
Grants permission to list versions of saved query on your account |
List |
|||
Grants permission to list tabs on your account |
List |
|||
Grants permission to list tagged resources |
Read |
|||
Grants permission to list the tags of an sqlworkbench resource |
Read |
|||
Grants permission to provide account settings with the request |
Write |
|||
Grants permission to update account-wide custom context |
Write |
|||
Grants permission to update sql generation context |
Write |
|||
Grants permission to create or update a tab on your account |
Write |
|||
Grants permission to update workspace settings on your account |
Write |
|||
Grants permission to restore a notebook on your account to a version |
Write |
|||
Grants permission to tag an sqlworkbench resource |
Tagging, Write |
|||
Grants permission to untag an sqlworkbench resource |
Tagging, Write |
|||
Grants permission to update account-wide connection settings |
Write |
|||
Grants permission to update account-wide export settings |
Write |
|||
Grants permission to update account-wide general settings |
Write |
|||
Grants permission to update account-wide text to SQL settings |
Write |
|||
Grants permission to update a chart on your account |
Write |
|||
Grants permission to update a connection on your account |
Write |
|||
Grants permission to move files on your account |
Write |
|||
Grants permission to update a folder's name and details on your account |
Write |
|||
Grants permission to update a notebook metadata on your account |
Write |
|||
Grants permission to update a notebook cell content on your account |
Write |
|||
Grants permission to update a notebook cell layout on your account |
Write |
|||
Grants permission to update a saved query on your account |
Write |
Resource types defined by Amazon SQL Workbench
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 |
|---|---|---|
arn:${Partition}:sqlworkbench:${Region}:${Account}:chart/${ResourceId} |
||
arn:${Partition}:sqlworkbench:${Region}:${Account}:connection/${ResourceId} |
||
arn:${Partition}:sqlworkbench:${Region}:${Account}:notebook/${ResourceId} |
||
arn:${Partition}:sqlworkbench:${Region}:${Account}:query/${ResourceId} |
Condition keys for Amazon SQL Workbench
Amazon SQL Workbench defines the following condition keys that can be used in the
Condition element of an IAM policy.
| Condition keys | Description | Type |
|---|---|---|
Filters access by the tags that are passed in the request |
String |
|
Filters access by the tags that are associated with the resource |
String |
|
Filters access by the tag keys that are passed in the request |
ArrayOfString |