Re: Grant all question

On 7/19/06, Ganesh Raja <ganesh.raja_at_gmail.com> 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_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/
>

ok guys thanks for the reply

-- 
regards,

Sinardy

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