Re: Grant all question

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,

Sinardy

Other related posts: