Re: Grant all question
- From: Mladen Gogala <gogala@xxxxxxxxxxxxx>
- To: oracle.rdbms@xxxxxxxxx
- Date: Tue, 18 Jul 2006 23:58:40 -0400
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
