Re: user creation with similar profile

  • From: "Syed Jaffar Hussain" <sjaffarhussain@xxxxxxxxx>
  • To: nileshkum@xxxxxxxxx
  • Date: Wed, 27 Jun 2007 10:13:53 +0300

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@xxxxxxxxx> 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."

Other related posts: