# clone a user **URL:** \ **Category:** Toad for Oracle & DevOps Toolkit\ **Created:** [May 22, 2018, 1:19pm UTC](https://forums.toadworld.com/t/clone-a-user/40952 "2018-05-22T13:19:33Z")\ **Posts on this page:** 8\ **Page:** 1
**Author:** ![marvin.griffin](https://avatars.discourse-cdn.com/v4/letter/m/b5a626/32.png) [@marvin.griffin](https://forums.toadworld.com/u/marvin.griffin)\ **Post date:** [May 22, 2018, 1:19pm UTC](https://forums.toadworld.com/t/clone-a-user/40952/1 "2018-05-22T13:19:33Z")
how to create userB just like userA in TOAD? 12 ---
**Author:** ![JohnDorlon](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/johndorlon/32/9997_2.png) [@JohnDorlon](https://forums.toadworld.com/u/JohnDorlon)\ **Post date:** [May 22, 2018, 1:22pm UTC](https://forums.toadworld.com/t/clone-a-user/40952/2 "2018-05-22T13:22:18Z")
Find the user in the Schema Browser. RIght-click. Choose Clone/Copy. ---
**Author:** ![ltansey](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/ltansey/32/348_2.png) [@ltansey](https://forums.toadworld.com/u/ltansey)\ **Post date:** [May 22, 2018, 2:29pm UTC](https://forums.toadworld.com/t/clone-a-user/40952/3 "2018-05-22T14:29:08Z")
That’s nifty - I did not know about the right click option. Also extremely handy, and lets you copy/clone a user from one db to another: use the Create Script, replace all the username with whatever you like, pop in the new pw, and run as needed. Works great! ---
**Author:** ![alanrosenthal](https://avatars.discourse-cdn.com/v4/letter/a/b77776/32.png) [@alanrosenthal](https://forums.toadworld.com/u/alanrosenthal)\ **Post date:** [May 22, 2018, 2:33pm UTC](https://forums.toadworld.com/t/clone-a-user/40952/4 "2018-05-22T14:33:16Z")
Not to sound greedy 🙂 but is there a way to clone an entire schema? Currently, I’m using a data pump export and import but if Toad could do it that would be very cool. Thanks, Alan ---
**Author:** ![JohnDorlon](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/johndorlon/32/9997_2.png) [@JohnDorlon](https://forums.toadworld.com/u/JohnDorlon)\ **Post date:** [May 22, 2018, 2:38pm UTC](https://forums.toadworld.com/t/clone-a-user/40952/5 "2018-05-22T14:38:18Z")
There are lots of right-click features throughout Toad. Explore that. If the schema does not contain data, you could use Generate Schema Script. There is also Data Subset Wizard (you could subset at 100%) as long as you don’t have LONG or any datatype that won’t copy with “create table as select”. Otherwise, Toad’s got a wizard to guide you through datapump, that may help. ---
**Author:** ![ltansey](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/ltansey/32/348_2.png) [@ltansey](https://forums.toadworld.com/u/ltansey)\ **Post date:** [May 22, 2018, 5:31pm UTC](https://forums.toadworld.com/t/clone-a-user/40952/6 "2018-05-22T17:31:59Z")
Oh, I use lots of right click options. 🙂 Just never noticed the clone/copy. I’ll have to read through the options again; I’m probably a little too quickly going for what I already know. ---
**Author:** ![marvin.griffin](https://avatars.discourse-cdn.com/v4/letter/m/b5a626/32.png) [@marvin.griffin](https://forums.toadworld.com/u/marvin.griffin)\ **Post date:** [May 24, 2018, 1:13pm UTC](https://forums.toadworld.com/t/clone-a-user/40952/7 "2018-05-24T13:13:07Z")
Thank you John! WHERE IS ALL OF THE GOOD TOAD DOCUMENTATION? -MG **Marvin Griffin** SR Oracle Applications DBA **O:** 301-206-8336 **|** **C: 240-636-3010** **|** **E:** [marvin\_griffin@wsscwater.com](mailto:marvin_griffin@wsscwater.com) Washington Suburban Sanitary Commission, 14501 Sweitzer Lane, Laurel, MD 20707 [www.wsscwater.com](http://www.wsscwater.com/) - For 100 years, WSSC has proudly served the citizens of Prince George’s and Montgomery counties – providing drinking water that has always met strict Safe Drinking Water Act standards and protecting the environment through vital water resource recovery services.\* - - _Our vision is to be THE world-class water utility, where excellent products and services are always on tap._ **From:** John Dorlon [[mailto:bounce-jdorlon@toadworld.com](mailto:bounce-jdorlon@toadworld.com)] **Sent:** Tuesday, May 22, 2018 4:23 PM **To:** [toadoracle@toadworld.com](mailto:toadoracle@toadworld.com) **Subject:** RE: [Toad for Oracle - Discussion Forum] clone a user **[RE: clone a user](https://linkprotect.cudasvc.com/url?a=https%3a%2f%2fcommunity.toadworld.com%2fproducts%2ftoad-for-oracle%2ff%2f10%2fp%2f35371%2f70625%2370625&c=E,1,dIBYmQwK_H3URPmqJcaPnazvmT6PV_gIOpQW39nZL9ZWSwxNb-z07zNQ-51ZwBe8v8uZGcqSwDG1WbjTv2hI1p2PyzxAe-qaa8Og7ZkOzDYMmGkQ__pHeQejTw,,&typo=1)** Reply by John Dorlon Find the user in the Schema Browser. RIght-click. Chose Clone/Copy. To reply, please reply-all to this email. [Stop receiving emails](https://linkprotect.cudasvc.com/url?a=https%3a%2f%2fcommunity.toadworld.com%2fproducts%2ftoad-for-oracle%2ff%2f10%2ft%2f35371%3fsubscribe%3dfalse&c=E,1,50QFoOQH3C9rIRLWzROD6UO0w74adefRct5KuFbeKQgLbzehM0GLWwhY6SFVLsAlFN5To57MXskWENqwiRcZgf1aeThFk8Af6JbLclfSrF_j5Q,,&typo=1) on this subject. Or [ Unsubscribe from Toad for Oracle Forum](https://linkprotect.cudasvc.com/url?a=https%3a%2f%2fcommunity.toadworld.com%2fproducts%2ftoad-for-oracle%2ff%2f10%3fsubscribe%3dfalse&c=E,1,W_ik2NT_SMb6W12NjsQVLXh5vY6HEuiqRoMXjUS9e2KD21KVHstMe1xnnytUhQAgajuOR7qTcYGGDnaPZ4k6u175Xme7So-mIp0jMgTElw,,&typo=1) notifications altogether. Toad for Oracle - Discussion Forum [Flag](https://linkprotect.cudasvc.com/url?a=https%3a%2f%2fcommunity.toadworld.com%2fproducts%2ftoad-for-oracle%2ff%2f10%2fp%2f35371%2f70625%3fAbuseContentId%3d6814f72c-70f1-4cc2-b968-111d71b20e55%26AbuseContentTypeId%3df586769b-0822-468a-b7f3-a94d480ed9b0%26AbuseFlag%3dtrue&c=E,1,mNmiDJonnxI16M0tJlq_hkZhOj64zihmtbXtEsHDRUijW2Kg9OTRhlARu5xlBWttlv0AVy9OtiYL4krXllW_cOMUtTlmhg38TlsSWx56yI8,&typo=1) this post as spam/abuse. ---
**Author:** ![JohnDorlon](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/johndorlon/32/9997_2.png) [@JohnDorlon](https://forums.toadworld.com/u/JohnDorlon)\ **Post date:** [May 24, 2018, 2:41pm UTC](https://forums.toadworld.com/t/clone-a-user/40952/8 "2018-05-24T14:41:45Z")
Help -\> Contents? Google or Toadworld search? There are also books about Toad that you can buy on Amazon.