Re: [Q] way to re-gernerate ROLE privilege ?

If you just need the table privs for the role, this will do. Give it the role name.

SELECT 'GRANT '||privilege||' on '||owner||'.'||TABLE_NAME||' TO '||grantee= ||
=09decode(grantable,'YES',' with grant option;',';')
=09FROM dba_tab_privs

      WHERE grantee=3Dupper('&&1')

--
http://www.freelists.org/webpage/oracle-l