Menu Role Auth icon

Menu Role Auth

Authenticate users and check menu role permissions with Redis caching

Actions2

Refresh Cache

AI-generated

Summary

Refreshes the menu-role cache by querying the configured PostgreSQL schema and table, then storing the rows in Redis under the configured key with the configured TTL.

Inputs

  • Cache Key — Redis key used to store the menu-role data; defaults to postgres_cache_base_menuroles.
  • Cache TTL (Seconds) — Cache expiration in seconds; defaults to 21600 (6 hours).
  • Schema — PostgreSQL schema to query; defaults to public.
  • Table — PostgreSQL table to query; defaults to base_menuRoles.

Output shape

A single item on the Access Granted output containing success: true, a success message, the number of rows cached as itemCount, and the configured cacheTtl; the Access Denied output is empty.

Requires Redis and PostgreSQL credentials. The query selects menuId, role_short_id, limit_org, limit_user, and limit_readonly from the configured table. The Pass Through Input option is declared but is not used by this operation.

Links

Discussion