Les traductions sont fournies par des outils de traduction automatique. En cas de conflit entre le contenu d'une traduction et celui de la version originale en anglais, la version anglaise prévaudra.
AmazonRedshiftQueryEditorV2ReadWriteSharing
Description : Permet de travailler avec Amazon Redshift Query Editor V2 avec partage de ressources. Le mandant autorisé peut lire, écrire et partager ses propres ressources. Le principal autorisé peut lire et mettre à jour les ressources partagées avec son équipe. Cette politique permet également d’accéder à d’autres services requis. Cela inclut les autorisations permettant de répertorier les clusters Amazon Redshift et de gérer les secrets de l'éditeur de requête V2 du principal dans AWS Secrets Manager.
AmazonRedshiftQueryEditorV2ReadWriteSharing
est une politique AWS gérée.
Utilisation de cette politique
Vous pouvez vous associer AmazonRedshiftQueryEditorV2ReadWriteSharing
à vos utilisateurs, groupes et rôles.
Détails de la politique
-
Type : politique AWS gérée
-
Heure de création : 24 septembre 2021, 14:25 UTC
-
Heure modifiée : 21 février 2024, 17h30 UTC
-
ARN:
arn:aws:iam::aws:policy/AmazonRedshiftQueryEditorV2ReadWriteSharing
Version de la politique
Version de la politique : v9 (par défaut)
La version par défaut de la politique est celle qui définit les autorisations associées à la politique. Lorsqu'un utilisateur ou un rôle doté de la politique fait une demande d'accès à une AWS ressource, AWS vérifie la version par défaut de la politique pour déterminer s'il convient d'autoriser la demande.
Document de politique JSON
{ "Version" : "2012-10-17", "Statement" : [ { "Sid" : "RedshiftPermissions", "Effect" : "Allow", "Action" : [ "redshift:DescribeClusters", "redshift-serverless:ListNamespaces", "redshift-serverless:ListWorkgroups" ], "Resource" : "*" }, { "Sid" : "SecretsManagerPermissions", "Effect" : "Allow", "Action" : [ "secretsmanager:CreateSecret", "secretsmanager:GetSecretValue", "secretsmanager:DeleteSecret", "secretsmanager:TagResource" ], "Resource" : "arn:aws:secretsmanager:*:*:sqlworkbench!*", "Condition" : { "StringEquals" : { "secretsmanager:ResourceTag/sqlworkbench-resource-owner" : "${aws:userid}" } } }, { "Sid" : "ResourceGroupsTaggingPermissions", "Effect" : "Allow", "Action" : [ "tag:GetResources" ], "Resource" : "*", "Condition" : { "StringEquals" : { "aws:CalledViaLast" : "sqlworkbench.amazonaws.com" } } }, { "Sid" : "AmazonRedshiftQueryEditorV2NonResourceLevelPermissions", "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" : "*" }, { "Sid" : "AmazonRedshiftQueryEditorV2CreateOwnedResourcePermissions", "Effect" : "Allow", "Action" : [ "sqlworkbench:CreateConnection", "sqlworkbench:CreateSavedQuery", "sqlworkbench:CreateChart", "sqlworkbench:CreateNotebook", "sqlworkbench:DuplicateNotebook", "sqlworkbench:CreateNotebookFromVersion", "sqlworkbench:ImportNotebook" ], "Resource" : "*", "Condition" : { "StringEquals" : { "aws:RequestTag/sqlworkbench-resource-owner" : "${aws:userid}" } } }, { "Sid" : "AmazonRedshiftQueryEditorV2OwnerSpecificPermissions", "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" : "*", "Condition" : { "StringEquals" : { "aws:ResourceTag/sqlworkbench-resource-owner" : "${aws:userid}" } } }, { "Sid" : "AmazonRedshiftQueryEditorV2TagOnlyUserIdPermissions", "Effect" : "Allow", "Action" : "sqlworkbench:TagResource", "Resource" : "*", "Condition" : { "ForAllValues:StringEquals" : { "aws:TagKeys" : "sqlworkbench-resource-owner" }, "StringEquals" : { "aws:ResourceTag/sqlworkbench-resource-owner" : "${aws:userid}", "aws:RequestTag/sqlworkbench-resource-owner" : "${aws:userid}" } } }, { "Sid" : "AmazonRedshiftQueryEditorV2TeamReadWriteAccessPermissions", "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" : "*", "Condition" : { "StringEquals" : { "aws:ResourceTag/sqlworkbench-team" : "${aws:PrincipalTag/sqlworkbench-team}" } } }, { "Sid" : "AmazonRedshiftQueryEditorV2TagOnlyTeamPermissions", "Effect" : "Allow", "Action" : "sqlworkbench:TagResource", "Resource" : "*", "Condition" : { "ForAllValues:StringEquals" : { "aws:TagKeys" : "sqlworkbench-team" }, "StringEquals" : { "aws:ResourceTag/sqlworkbench-resource-owner" : "${aws:userid}", "aws:RequestTag/sqlworkbench-team" : "${aws:PrincipalTag/sqlworkbench-team}" } } }, { "Sid" : "AmazonRedshiftQueryEditorV2UntagOnlyTeamPermissions", "Effect" : "Allow", "Action" : "sqlworkbench:UntagResource", "Resource" : "*", "Condition" : { "ForAllValues:StringEquals" : { "aws:TagKeys" : "sqlworkbench-team" }, "StringEquals" : { "aws:ResourceTag/sqlworkbench-resource-owner" : "${aws:userid}" } } } ] }