grant all on public.c_account to eia
SELECT table_schema || ‘.‘ || table_name
FROM information_schema.TABLES WHERE table_schema =‘public‘
select ‘grant all on ‘ || table_schema || ‘.‘ || table_name || ‘ to nsaudit‘
FROM information_schema.TABLES WHERE table_schema =‘public‘