is there in db2 luw a view/tablefunction/sql that could list you all grants that have been given to a role
or do you need to combine individual tables as sysibm.systabauth sysibm.sysroles and select granteetype='R' and join on roleid to find tablegrants and repeat this for other objects
------------------------------
Thank for all update/help
Best Regards, Guy Przytula
------------------------------
#Db2