AmazonRedshiftQueryEditorV2ReadWriteSharing details (in AWS console)
Policy Name
AmazonRedshiftQueryEditorV2ReadWriteSharing
Description
Grants the ability to work with Amazon Redshift Query Editor V2 with sharing of resources. The granted principal can read, write and share its own resources. The granted principal can read and update the resources shared with its team. This policy also grants access to other required services. This includes permissions to list the Amazon Redshift clusters and manage the Query Editor V2 secrets of the principal in AWS Secrets Manager.
ARN
arn:aws:iam::aws:policy/AmazonRedshiftQueryEditorV2ReadWriteSharing
Path
/
PolicyId
ANPAZKAPJZG4LIWZX3BPO
AttachmentCount
0
[
{
"Effect": "Allow",
"Action": [
"redshift:DescribeClusters",
"redshift-serverless:ListNamespaces",
"redshift-serverless:ListWorkgroups"
],
"Resource": [
"*"
]
},
{
"Effect": "Allow",
"Action": [
"secretsmanager:CreateSecret",
"secretsmanager:GetSecretValue",
"secretsmanager:DeleteSecret",
"secretsmanager:TagResource"
],
"Resource": [
"arn:aws:secretsmanager:*:*:sqlworkbench!*"
]
},
{
"Effect": "Allow",
"Action": [
"tag:GetResources"
],
"Resource": [
"*"
]
},
{
"Effect": "Allow",
"Action": [
"sqlworkbench:CreateFolder",
"sqlworkbench:PutTab",
"sqlworkbench:BatchDeleteFolder",
"sqlworkbench:DeleteTab",
"sqlworkbench:GenerateSession",
"sqlworkbench:GetAccountInfo",
"sqlworkbench:GetAccountSettings",
"sqlworkbench:GetUserInfo",
"sqlworkbench:GetUserWorkspaceSettings",
"sqlworkbench:PutUserWorkspaceSettings",
"sqlworkbench:ListConnections",
"sqlworkbench:ListFiles",
"sqlworkbench:ListTabs",
"sqlworkbench:UpdateFolder",
"sqlworkbench:ListRedshiftClusters",
"sqlworkbench:DriverExecute",
"sqlworkbench:ListTaggedResources",
"sqlworkbench:ListQueryExecutionHistory",
"sqlworkbench:GetQueryExecutionHistory",
"sqlworkbench:ListNotebooks",
"sqlworkbench:GetSchemaInference",
"sqlworkbench:GetAutocompletionMetadata",
"sqlworkbench:GetAutocompletionResource"
],
"Resource": [
"*"
]
},
{
"Effect": "Allow",
"Action": [
"sqlworkbench:CreateConnection",
"sqlworkbench:CreateSavedQuery",
"sqlworkbench:CreateChart",
"sqlworkbench:CreateNotebook",
"sqlworkbench:DuplicateNotebook",
"sqlworkbench:CreateNotebookFromVersion",
"sqlworkbench:ImportNotebook"
],
"Resource": [
"*"
]
},
{
"Effect": "Allow",
"Action": [
"sqlworkbench:DeleteChart",
"sqlworkbench:DeleteConnection",
"sqlworkbench:DeleteSavedQuery",
"sqlworkbench:GetChart",
"sqlworkbench:GetConnection",
"sqlworkbench:GetSavedQuery",
"sqlworkbench:ListSavedQueryVersions",
"sqlworkbench:UpdateChart",
"sqlworkbench:UpdateConnection",
"sqlworkbench:UpdateSavedQuery",
"sqlworkbench:AssociateConnectionWithTab",
"sqlworkbench:AssociateQueryWithTab",
"sqlworkbench:AssociateConnectionWithChart",
"sqlworkbench:AssociateNotebookWithTab",
"sqlworkbench:UpdateFileFolder",
"sqlworkbench:ListTagsForResource",
"sqlworkbench:GetNotebook",
"sqlworkbench:UpdateNotebook",
"sqlworkbench:DeleteNotebook",
"sqlworkbench:DuplicateNotebook",
"sqlworkbench:CreateNotebookCell",
"sqlworkbench:DeleteNotebookCell",
"sqlworkbench:UpdateNotebookCellContent",
"sqlworkbench:UpdateNotebookCellLayout",
"sqlworkbench:BatchGetNotebookCell",
"sqlworkbench:ListNotebookVersions",
"sqlworkbench:CreateNotebookVersion",
"sqlworkbench:GetNotebookVersion",
"sqlworkbench:DeleteNotebookVersion",
"sqlworkbench:RestoreNotebookVersion",
"sqlworkbench:CreateNotebookFromVersion",
"sqlworkbench:ExportNotebook",
"sqlworkbench:ImportNotebook"
],
"Resource": [
"*"
]
},
{
"Effect": "Allow",
"Action": [
"sqlworkbench:TagResource"
],
"Resource": [
"*"
]
},
{
"Effect": "Allow",
"Action": [
"sqlworkbench:GetChart",
"sqlworkbench:GetConnection",
"sqlworkbench:GetSavedQuery",
"sqlworkbench:ListSavedQueryVersions",
"sqlworkbench:ListTagsForResource",
"sqlworkbench:UpdateChart",
"sqlworkbench:UpdateConnection",
"sqlworkbench:UpdateSavedQuery",
"sqlworkbench:AssociateConnectionWithTab",
"sqlworkbench:AssociateQueryWithTab",
"sqlworkbench:AssociateConnectionWithChart",
"sqlworkbench:AssociateNotebookWithTab",
"sqlworkbench:GetNotebook",
"sqlworkbench:DuplicateNotebook",
"sqlworkbench:BatchGetNotebookCell",
"sqlworkbench:ListNotebookVersions",
"sqlworkbench:GetNotebookVersion",
"sqlworkbench:CreateNotebookFromVersion",
"sqlworkbench:ExportNotebook"
],
"Resource": [
"*"
]
},
{
"Effect": "Allow",
"Action": [
"sqlworkbench:TagResource"
],
"Resource": [
"*"
]
},
{
"Effect": "Allow",
"Action": [
"sqlworkbench:UntagResource"
],
"Resource": [
"*"
]
}
]