Re: Grant all question

On 07/18/2006 11:39:34 PM, Sinardy Xing wrote:
> Hi guys,
>
> I have schema A and A own 20 many objects (tables, functions, triggers and
> others stuff).
>
> How to create user B having same privileges with what A can do with his own
> objects
>
> Something like this
> GRANT ALL OF a TO b;
>

select 'grant all on A.'||table_name||' to B;' from dba_tables where owner='A';
It's an ancient trick:
set pagesize 0
set trimout on
set trimspool on
spool /tmp/destroy_security.sql
/
spool off
@/tmp/destroy_security

It's called "SQL generating SQL".

-- 
Mladen Gogala
http://www.mgogala.com

--
http://www.freelists.org/webpage/oracle-l