user creation with similar profile

  • From: "nilesh kumar" <nileshkum@xxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Tue, 26 Jun 2007 22:35:07 -0700

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.

Other related posts: