how-to get the list of all priviledges per group in Netezza

export db='SYSTEM'
export sql='SELECT GROUPNAME FROM _v_sys_group_priv GROUP BY GROUPNAME'

for grp in `nzsql -q -r -t -d $db -c "$sql"` ; do nzsql -d $db -c "\dpg $grp" ; done ;