Re: Enterprise Manager Question..

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

host echo " From User_Tables;" >>create_grants.sql

spo grants.sql

_at_create_grants

spo off

set echo on head on term on feed on ver on pages 23

_at_grants

:cool:

--
Posted via http://dbforums.com