Re: Grant all question

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_at_gmail.com> wrote:
>
>
>
> On 7/19/06, Mladen Gogala <gogala_at_sbcglobal.net> 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/

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