Re: user creation with similar profile

You didn't tell us the Oracle version which you are using. There are many workaround for this.

In 10g, you can simpy use datapumps to achieve this.

   export the schema without data
   import using remap_schema option.

If you have OEM, you can also use the feature of create like.

May be, there are other workaround as well.

On 6/27/07, nilesh kumar <nileshkum_at_gmail.com> wrote:
>
> Can any one help to write a sql statement in which , i want to create a
> new user with a similar profile of different user.Say for example there is
> a user "A" who has so n so privilege and so n so table space assigned to him
> etc..., i want to create a user "B" who has the same privilege as A and same
> tablespace assigned to A etc...
>
> Thanks
>
> Nilesh Soni.
>

-- 
Best Regards,
Syed Jaffar Hussain
Oracle ACE
8i,9i & 10g OCP DBA

http://jaffardba.blogspot.com/
http://www.oracle.com/technology/community/oracle_ace/ace1.html#hussain
----------------------------------------------------------------------------------

"Winners don't do different things. They do things differently."

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