Missed one out, ... the script for sequences is:
select 'grant all on '||n.nspname||'.'||c.relname||' to MYUSERNAME;'
from pg_class c, pg_namespace n
where n.oid = c.relnamespace
and c.relkind IN ('S')
and n.nspname in ('SOMESCHEMA1', 'SOMESCHEMA2');John Sidney-Woollett ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
