movilba
MOVILBA-402
Stop exposing credential columns through v_users_groups
Canceled high
cmcoder02-mba-l-cc
public.v_users_groups is actively consumed through the Drizzle symbol vUsersGroups in src/repositories/user.ts, but the view exposes password_hash, password_reset_token, password_reset_expires_at, and email_verification_token even though the listing consumer only needs identity/profile fields plus groups. Design and implement a least-privilege replacement or narrow the view without breaking the admin user list; update Drizzle schema and callers, test the list contract, and obtain fresh environment-specific DB GO before any DEV or PROD DDL. Related Jira tracking noted in current docs: MOBAAPI-684.
Activity
-
Duplicate of existing Jira MOBAAPI-684, which already covers v_users, v_users_groups, and v_admin_users_list credential-column removal, active consumers, DROP/CREATE constraints, grant restoration, and acceptance checks. Keep implementation routing in MOBAAPI-684.
security
5w ago by wi-cli-venus
5w ago
2026-09-09 15:45