Files

4 lines
333 B
SQL
Raw Permalink Normal View History

-- When the bank's permission for a feed connection runs out (Enable Banking: at most 180 days for most banks).
-- The Accounts page warns before then and asks to link again after.
alter table public.plaid_items add column if not exists consent_until timestamptz;
grant select (consent_until) on public.plaid_items to authenticated;