alicloud_accountalicloud_action_trailalicloud_cas_certificatealicloud_cms_monitor_hostalicloud_cs_kubernetes_clusteralicloud_cs_kubernetes_cluster_nodealicloud_ecs_auto_provisioning_groupalicloud_ecs_autoscaling_groupalicloud_ecs_diskalicloud_ecs_disk_metric_read_iopsalicloud_ecs_disk_metric_read_iops_dailyalicloud_ecs_disk_metric_read_iops_hourlyalicloud_ecs_disk_metric_write_iopsalicloud_ecs_disk_metric_write_iops_dailyalicloud_ecs_disk_metric_write_iops_hourlyalicloud_ecs_imagealicloud_ecs_instancealicloud_ecs_instance_metric_cpu_utilization_dailyalicloud_ecs_instance_metric_cpu_utilization_hourlyalicloud_ecs_key_pairalicloud_ecs_launch_templatealicloud_ecs_network_interfacealicloud_ecs_regionalicloud_ecs_security_groupalicloud_ecs_snapshotalicloud_ecs_zonealicloud_kms_keyalicloud_kms_secretalicloud_oss_bucketalicloud_ram_access_keyalicloud_ram_credential_reportalicloud_ram_groupalicloud_ram_password_policyalicloud_ram_policyalicloud_ram_rolealicloud_ram_security_preferencealicloud_ram_useralicloud_rds_backupalicloud_rds_databasealicloud_rds_instancealicloud_rds_instance_metric_connectionsalicloud_rds_instance_metric_connections_dailyalicloud_rds_instance_metric_cpu_utilizationalicloud_rds_instance_metric_cpu_utilization_dailyalicloud_rds_instance_metric_cpu_utilization_hourlyalicloud_security_center_field_statisticsalicloud_security_center_versionalicloud_slb_load_balanceralicloud_vpcalicloud_vpc_dhcp_options_setalicloud_vpc_eipalicloud_vpc_flow_logalicloud_vpc_nat_gatewayalicloud_vpc_network_aclalicloud_vpc_route_entryalicloud_vpc_route_tablealicloud_vpc_ssl_vpn_client_certalicloud_vpc_ssl_vpn_serveralicloud_vpc_vpn_connectionalicloud_vpc_vpn_customer_gatewayalicloud_vpc_vpn_gatewayalicloud_vpc_vswitch
Table: alicloud_ram_group
A RAM group is a collection of RAM users. Groups let you specify permissions for multiple users, which makes it easier to manage the permissions for those users.
Examples
User details associated with each RAM group
select name as group_name, iam_user ->> 'UserName' as user_name, iam_user ->> 'DisplayName' as display_name, iam_user ->> 'JoinDate' as user_join_datefrom alicloud_ram_group cross join jsonb_array_elements(users) as iam_user;
List the policies attached to each RAM group
select name as group_name, policies ->> 'PolicyName' as policy_name, policies ->> 'PolicyType' as policy_type, policies ->> 'DefaultVersion' as policy_default_version, policies ->> 'AttachDate' as policy_attachment_datefrom alicloud_ram_group, jsonb_array_elements(attached_policy) as policies;
List of RAM groups with no users added to it
select name as group_name, create_date, usersfrom alicloud_ram_groupwhere users = '[]';
Query examples
- ram_all_policies_for_group
- ram_all_policies_for_user
- ram_group_1_year_count
- ram_group_24_hours_count
- ram_group_30_90_days_count
- ram_group_30_days_count
- ram_group_90_365_days_count
- ram_group_age_table
- ram_group_count
- ram_group_input
- ram_group_overview
- ram_groups_by_account
- ram_groups_by_creation_month
- ram_groups_for_ram_policy
- ram_groups_for_ram_user
- ram_groups_policies_count
- ram_groups_users_count
- ram_groups_with_no_attached_policy_count
- ram_groups_without_policies
- ram_groups_without_users
- ram_groups_without_users_count
- ram_policies_for_ram_group
- ram_user_manage_policies_sankey
- ram_users_for_group
- ram_users_for_ram_group
.inspect alicloud_ram_group
Resource Access Management groups who can login via the console or access keys.
Name | Type | Description |
---|---|---|
_ctx | jsonb | Steampipe context in JSON form, e.g. connection_name. |
account_id | text | The Alicloud Account ID in which the resource is located. |
akas | jsonb | Array of globally unique identifier strings (also known as) for the resource. |
arn | text | The Alibaba Cloud Resource Name (ARN) of the RAM user group. |
attached_policy | jsonb | A list of policies attached to a RAM user group. |
comments | text | The description of the RAM user group. |
create_date | timestamp with time zone | The time when the RAM user group was created. |
name | text | The name of the RAM user group. |
region | text | The Alicloud region in which the resource is located. |
title | text | Title of the resource. |
update_date | timestamp with time zone | The time when the RAM user group was modified. |
users | jsonb | A list of users in the group. |