Skip to main content
Version: 0.0.25

Table: iam_user

Table to manage AWS IAM users. An AWS Identity and Access Management (IAM) user is an entity that you create in AWS to represent the person or application that uses it to interact with AWS. A user in AWS consists of a name and credentials.

Example

INSERT INTO iam_user (user_name, path, attached_policies_arns) VALUES ('user_name', '/username/',
array['arn:aws:iam::aws:policy/service-role/AmazonECSTaskExecutionRolePolicy']);

SELECT * FROM iam_user WHERE user_name = 'user_name';

DELETE FROM iam_user WHERE user_name = 'user_name';

See

Columns

Optional access_keys: access_key[]

Access Keys associated to an specific user

See

https://docs.aws.amazon.com/IAM/latest/UserGuide/id_credentials_access-keys.html

Optional arn: string

AWS ARN to identify the user

Optional attached_policies_arns: string[]

ARN for the policies that are attached to this specific role

See

https://docs.aws.amazon.com/IAM/latest/UserGuide/access_policies_job-functions_create-policies.html

create_date: date

Creation date

Optional path: string

The path to the user must start and end with / only can contain alphanumeric characters

See

https://docs.aws.amazon.com/IAM/latest/UserGuide/reference_identifiers.html

Optional user_id: string

AWS generated ID for the user

user_name: string

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