postgres-list-roles

tools:
  list_indexes:
    kind: postgres-list-roles
    source: postgres-source
    description: |
      Lists all the user-created roles in the instance . It returns the role name,
      Object ID, the maximum number of concurrent connections the role can make,
      along with boolean indicators for: superuser status, privilege inheritance
      from member roles, ability to create roles, ability to create databases,
      ability to log in, replication privilege, and the ability to bypass
      row-level security, the password expiration timestamp, a list of direct
      members belonging to this role, and a list of other roles/groups that this
      role is a member of.

{
 "role_name": "Name of the role",
 "oid": "Object ID of the role",
 "connection_limit": "Maximum concurrent connections allowed (-1 for no limit)",
 "is_superuser": "Boolean, true if the role is a superuser",
 "inherits_privileges": "Boolean, true if the role inherits privileges of roles it is a member of",
 "can_create_roles": "Boolean, true if the role can create other roles",
 "can_create_db": "Boolean, true if the role can create databases",
 "can_login": "Boolean, true if the role can log in",
 "is_replication_role": "Boolean, true if this is a replication role",
 "bypass_rls": "Boolean, true if the role bypasses row-level security policies",
 "valid_until": "Timestamp until the password is valid (null if forever)",
 "direct_members": ["Array of role names that are direct members of this role"],
 "member_of": ["Array of role names that this role is a member of"]
}