AmazonQLDBConsoleFullAccess

AdminAWS managedActivePermissions reviewedShow on map Compare

Summary

Provides full access to Amazon QLDB via the AWS Management Console.

Permissions imported from the AWS Managed Policy Reference Guide; other sections pending editorial review.

Identity

ARN: arn:aws:iam::aws:policy/AmazonQLDBConsoleFullAccess
Default version: v5
Created: 2019-09-05
Last edited: 2022-11-04
Services: dbqms, iam, kinesis, qldb

Control-plane actions (51)

By access level: 8 List, 11 Read, 2 Tagging, 30 Write.

Control-plane actions by service
Service	Granted	Access levels and limits	Granted by
DBQMS	All 13 actions (see the DBQMS page)	3 List, 1 Read, 9 Write; 0 restricted, 0 conditional	dbqms:*
IAM	1 of 190	1 Write; 1 restricted, 1 conditional	iam:PassRole
Kinesis	2 of 42	1 List, 1 Read; 0 restricted, 0 conditional	kinesis:DescribeStream, kinesis:ListStreams
QLDB	All 35 actions (see the QLDB page)	4 List, 9 Read, 2 Tagging, 20 Write; 0 restricted, 0 conditional	qldb:CancelJournalKinesisStream, qldb:CreateLedger, qldb:DeleteLedger, qldb:DescribeJournalKinesisStream, qldb:DescribeJournalS3Export, qldb:DescribeLedger, qldb:ExecuteStatement, qldb:ExportJournalToS3, qldb:GetBlock, qldb:GetDigest, qldb:GetRevision, qldb:InsertSampleData and 23 more

IAM: 1 actions

iam:PassRole (Write)

Kinesis: 2 actions

kinesis:DescribeStream (Read)
kinesis:ListStreams (List)

Data-plane actions (0)

By access level: none.

This policy grants no actions in this plane.

Excluded and conditional actions

No patterns are excluded by NotAction or Deny statements.

Resource scope and attachment

Resource scope across granted actions: all-resources.

Can be attached: Yes, to users, groups and roles.

Why this tier

Grants at least 80% of the write and permissions-management actions of: dbqms (9 of 9), qldb (20 of 20).
Grants iam:PassRole, but only for scoped roles or under conditions (for example iam:PassedToService).

Guidance

Pending editorial review. The permission data on this page comes straight from AWS; this section will be filled in once a reviewed guide exists.

Same service

Same domain

Frequently asked questions

Pending editorial review. The permission data on this page comes straight from AWS; this section will be filled in once a reviewed guide exists.

Policy JSON

Download policy.json

{
  "Version": "2012-10-17",
  "Statement": [
    {
      "Effect": "Allow",
      "Action": [
        "qldb:CreateLedger",
        "qldb:UpdateLedger",
        "qldb:UpdateLedgerPermissionsMode",
        "qldb:DeleteLedger",
        "qldb:ListLedgers",
        "qldb:DescribeLedger",
        "qldb:ExportJournalToS3",
        "qldb:ListJournalS3Exports",
        "qldb:ListJournalS3ExportsForLedger",
        "qldb:DescribeJournalS3Export",
        "qldb:CancelJournalKinesisStream",
        "qldb:DescribeJournalKinesisStream",
        "qldb:ListJournalKinesisStreamsForLedger",
        "qldb:StreamJournalToKinesis",
        "qldb:GetBlock",
        "qldb:GetDigest",
        "qldb:GetRevision",
        "qldb:TagResource",
        "qldb:UntagResource",
        "qldb:ListTagsForResource",
        "qldb:SendCommand",
        "qldb:ExecuteStatement",
        "qldb:ShowCatalog",
        "qldb:InsertSampleData",
        "qldb:PartiQLCreateTable",
        "qldb:PartiQLCreateIndex",
        "qldb:PartiQLDropTable",
        "qldb:PartiQLDropIndex",
        "qldb:PartiQLUndropTable",
        "qldb:PartiQLDelete",
        "qldb:PartiQLInsert",
        "qldb:PartiQLUpdate",
        "qldb:PartiQLSelect",
        "qldb:PartiQLHistoryFunction",
        "qldb:PartiQLRedact"
      ],
      "Resource": "*"
    },
    {
      "Effect": "Allow",
      "Action": [
        "dbqms:*"
      ],
      "Resource": "*"
    },
    {
      "Effect": "Allow",
      "Action": [
        "kinesis:ListStreams",
        "kinesis:DescribeStream"
      ],
      "Resource": "*"
    },
    {
      "Effect": "Allow",
      "Action": "iam:PassRole",
      "Resource": "*",
      "Condition": {
        "StringEquals": {
          "iam:PassedToService": "qldb.amazonaws.com"
        }
      }
    }
  ]
}

Version history

Current version v5, edited by AWS on 2022-11-04. Version history is recorded from 2026-11-11. Earlier versions are in the IAM console under Policy versions.

Attach snippets

AWS CLI

aws iam attach-role-policy --role-name ROLE_NAME --policy-arn arn:aws:iam::aws:policy/AmazonQLDBConsoleFullAccess
aws iam attach-user-policy --user-name USER_NAME --policy-arn arn:aws:iam::aws:policy/AmazonQLDBConsoleFullAccess
aws iam attach-group-policy --group-name GROUP_NAME --policy-arn arn:aws:iam::aws:policy/AmazonQLDBConsoleFullAccess

CloudFormation

Resources:
  ExampleRole:
    Type: AWS::IAM::Role
    Properties:
      AssumeRolePolicyDocument: {}  # replace with your trust policy
      ManagedPolicyArns:
        - arn:aws:iam::aws:policy/AmazonQLDBConsoleFullAccess

Terraform

resource "aws_iam_role_policy_attachment" "amazonqldbconsolefullaccess" {
  role       = aws_iam_role.example.name
  policy_arn = "arn:aws:iam::aws:policy/AmazonQLDBConsoleFullAccess"
}

CDK (TypeScript)

role.addManagedPolicy(
  iam.ManagedPolicy.fromAwsManagedPolicyName("AmazonQLDBConsoleFullAccess"),
);

Sources

Pending editorial review. No editorial sources are listed yet.