-- To tables
SELECT 'GRANT SELECT, INSERT, UPDATE, DELETE ON ' || relname || ' TO userxpto;'
FROM pg_class JOIN pg_namespace ON pg_namespace.oid = pg_class.relnamespace
WHERE nspname = 'public' AND relkind IN ('r', 'v');

-- To Sequences
SELECT 'GRANT USAGE, SELECT, UPDATE ON ' || relname || ' TO userxpto;'
from pg_class JOIN pg_namespace ON pg_namespace.oid = pg_class.relnamespace
where nspname = 'public' and relkind = 'S'