On 7/19/06, Mladen Gogala <gogala@xxxxxxxxxxxxx> wrote:
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
to use this method we can use dba_objects right to include procedures, functions and others?, I just checking wheather 10g got one command only, I need to prepare like 20 users like B. :)
-- regards,