select into a command...

From: Andrea <no_at_tin.it>
Date: Tue, 26 Jul 2005 23:46:21 +0200
Message-ID: <42e6af10$0$7030$5fc30a8@news.tiscali.it>

Hi,

i need make a grant on all table of a user (oracle 8.1.7) :

grant all on myuser.table1 to public;
grant all on myuser.table2 to public;
grant all on myuser.table3 to public;

ecc...

and i would like to know if possible run a select command during a grant (select table_name from all_tables where owner = 'MYUSER')?? otherwise i have to run a select with a spooler but i don't know what i do after this step..

thanks very much!!

bye Received on Tue Jul 26 2005 - 16:46:21 CDT