7

Does SQLDeveloper have a Toad-like tool to copy/clone an Oracle database user?

If not, I'll resort to: How to Clone a User in Oracle

Community
  • 1
  • 1
Ultimadj
  • 83
  • 1
  • 1
  • 5
  • Oracle Enterprise Manager for 10g - the java app distributed witht he client - does have "Create like..." functionality that can be used to copy a user and his/her rights and privileges. – Adam Musch Dec 23 '10 at 16:13

1 Answers1

16

In version 3 there is a DBA view. It can be displayed or hidden using the view menu. Once you have it displayed open the connection in the DBA section. Drill down to Security->Users and right click on the user you want to copy. The option you are looking for is create like.

Todd Pierce
  • 806
  • 5
  • 8
  • Bingo! Just what I was looking for. Thanks Todd! – Ultimadj Dec 23 '10 at 19:10
  • Just a quick note: copy object privileges is right there on the first tab, but is _not_ selected by default ( https://www.thatjeffsmith.com/archive/2015/12/trick-getting-all-the-privileges-grants-for-a-user/ ) – Justin May 24 '19 at 17:12