On 7/19/06, Ganesh Raja <ganesh.raja@xxxxxxxxx> wrote:
Yes you can use the DBA_OBJECTS where OWNER = 'A' to get this Same SQL Done. Also Join it with DBA_Users to get the UserName of eac of the Users.
HTH
- Ganesh
On 7/19/06, Sinardy Xing <oracle.rdbms@xxxxxxxxx> wrote: > > > > 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, > > > Sinardy >
-- ----------------------------------------------------------- http://iyertalks.blogspot.com/
ok guys thanks for the reply -- regards,