steampipe plugin install akeyless-community/akeyless

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,
rules
from
akeyless_role;

List all Roles created in the last 30 days

select
*
from
akeyless_role
where
creation_date >= CURRENT_TIMESTAMP - INTERVAL '30 days';

Schema for akeyless_role

NameTypeOperatorsDescription
_ctxjsonbSteampipe context in JSON form.
access_datetimestamp with time zoneThe date when the role was last accessed.
creation_datetimestamp with time zoneThe date when the role was created.
modification_datetimestamp with time zoneThe date when the role was last modified.
role_auth_methods_assocjsonbThe authentication methods associated with the role.
role_nametextThe name of the role.
rulesjsonbThe rules associated with the role.
sp_connection_nametext=, !=, ~~, ~~*, !~~, !~~*Steampipe connection name.
sp_ctxjsonbSteampipe context in JSON form.