Skip to main content
Version: 0.0.25

Table: iam_role

Table to manage AWS IAM roles. An IAM role is an IAM identity that you can create in your account that has specific permissions.

An IAM role is similar to an IAM user, in that it is an AWS identity with permission policies that determine what the identity can and cannot do in AWS. However, instead of being uniquely associated with one person, a role is intended to be assumable by anyone who needs it.

Also, a role does not have standard long-term credentials such as a password or access keys associated with it. Instead, when you assume a role, it provides you with temporary security credentials for your role session.


INSERT INTO iam_role (role_name, assume_role_policy_document) VALUES ('lambda_role_name', '{
Version: '2012-10-17',
Statement: [
Effect: 'Allow',
Principal: {
Service: '',
Action: 'sts:AssumeRole',

SELECT * FROM iam_role WHERE role_name = 'lambda_role_name';

DELETE FROM iam_role WHERE role_name = 'lambda_role_name';



Optional arn: string

AWS ARN to identify the role

assume_role_policy_document: Object

JSON blob to define the policy for the role Returns a set of temporary security credentials that you can use to access AWS resources that you might not normally have access to.


Type definition

[key: string]: any

Optional attached_policies_arns: string[]

ARN for the policies that are attached to this specific role


Optional description: string

Description for the role

role_name: string

Name for the role Guaranteed unique in AWS Maximum 128 characters. Use alphanumeric and '+=,.@-_' characters.