Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Grant all question

Re: Grant all question

From: Sinardy Xing <oracle.rdbms_at_gmail.com>
Date: Wed, 19 Jul 2006 13:46:29 +0800
Message-ID: <f52c14170607182246h14e059d5jebfccd58fbb98e8a@mail.gmail.com>


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://www.freelists.org/webpage/oracle-l
Received on Wed Jul 19 2006 - 00:46:29 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US