Not with OEM, you need dynamic sql and do something like this:
Set Time Off Timing Off Term Off
Set echo off pages 0 lin 80 head off ver off feed off recsep off Trim On
host echo "Select 'Grant Select On '||table_name|| ' To OtherUsr;'"
>create_grants. sql
spo grants.sql
@create_grants
spo off
set echo on head on term on feed on ver on pages 23
@grants
:cool:
--
Posted via http://dbforums.com