AWS Identity Store Group Membership represents the membership of a user in a group. It is used to manage and track the association between users and groups within the identity store.
By managing group memberships, you can control access and permissions for users within your organization and assign them to specific groups to define their level of access to resources and services.
You must specify an Identity Store ID in a
where clause (
group_id can be pass optionally in where clause.
selectidentity_store_id,group_id,membership_id,member_idfromaws_identitystore_group_membershipwhereidentity_store_id = 'd-1234567890';
Get user details of each group membership
selectm.membership_id,m.group_id,m.identity_store_id,u.name as user_namefromaws_identitystore_group_membership as m,aws_identitystore_user as uwherem.identity_store_id = 'd-1234567890'and u.identity_store_id = m.identity_store_idand u.id = m.member_id;
Get group details of each membership
selectm.membership_id,m.group_id,m.identity_store_id,g.name as group_namefromaws_identitystore_group_membership as m,aws_identitystore_group as gwherem.identity_store_id = 'd-1234567890'and g.identity_store_id = m.identity_store_idand g.id = m.group_id;
AWS Identity Store Group Membership
|_ctx||jsonb||Steampipe context in JSON form, e.g. connection_name.|
|account_id||text||The AWS Account ID in which the resource is located.|
|group_id||text||The identifier for a group in the identity store.|
|identity_store_id||text||The globally unique identifier for the identity store.|
|member_id||text||Specific identifier for a user indicates that the user is a member of the group.|
|membership_id||text||The identifier for a GroupMembership object in an identity store.|
|partition||text||The AWS partition in which the resource is located (aws, aws-cn, or aws-us-gov).|
|region||text||The AWS Region in which the resource is located.|
|title||text||Title of the resource.|