Re: Grant on all in user's schema
From: Yoram Zilberberg <elric_dm_at_netvision.net.il>
Date: 1996/06/07
Message-ID: <NEWTNews.834211559.12496.elric_dm_at_dialup.netvision.net.il>#1/1
Date: 1996/06/07
Message-ID: <NEWTNews.834211559.12496.elric_dm_at_dialup.netvision.net.il>#1/1
Try this:
SQL> set heading off SQL> set feedback off SQL> select 'grant all on ' || table_name || 'to THE_ROLE;'2> from user_tables
SQL> spool x.sql SQL> / SQL> spool off SQL> _at_x
the "x.sql" file is dynamicly created to hold all the grant comands.
good luck
Yoram Z. Received on Fri Jun 07 1996 - 00:00:00 CEST