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') -- //www.freelists.org/webpage/oracle-l