Table: akeyless_role
Access roles
Examples
List all Roles with complete information
select *from akeyless_role;
List all Roles by Name, Created Date, and Rules
select role_name, creation_date, rulesfrom akeyless_role;
List all Roles created in the last 30 days
select *from akeyless_rolewhere creation_date >= CURRENT_TIMESTAMP - INTERVAL '30 days';
Schema for akeyless_role
Name | Type | Operators | Description |
---|---|---|---|
_ctx | jsonb | Steampipe context in JSON form. | |
access_date | timestamp with time zone | The date when the role was last accessed. | |
creation_date | timestamp with time zone | The date when the role was created. | |
modification_date | timestamp with time zone | The date when the role was last modified. | |
role_auth_methods_assoc | jsonb | The authentication methods associated with the role. | |
role_name | text | The name of the role. | |
rules | jsonb | The rules associated with the role. | |
sp_connection_name | text | =, !=, ~~, ~~*, !~~, !~~* | Steampipe connection name. |
sp_ctx | jsonb | Steampipe context in JSON form. |