rem rem create roles and object privileges script rem rem Biju Thomas rem set pages 0 feedback off echo off verify off lines 150 trims on spool /tmp/crrole.sql select 'create role ' || ROLE || ';' from dba_roles where role like '&1' / select 'grant ' || PRIVILEGE ||' on '|| OWNER ||'.' || TABLE_NAME || ' to ' || GRANTEE ||';' from dba_tab_privs where grantee like '&1%' / spool off prompt Script generated and saved at /tmp/crrole.sql prompt