I don't user security manager but this is how I do it. I create a script spooled out from sqlplus that I run
set heading off
set pagesize o
spool cr_grant.sql
select 'grant select on '||table_name||' to select_role;'
from dba_tables
where owner = 'LAWD';
spool off
I then would log in as lawd and execute the script.




Reply With Quote