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‘
原文：https://www.cnblogs.com/modestlin/p/15226584.html