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.