Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Does SQLDeveloper have a tool to copy/clone users like Toad?

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

like image 973
Ultimadj Avatar asked Dec 23 '10 15:12

Ultimadj


People also ask

What is SQL Developer used for?

SQL Developer provides powerful editors for working with SQL, PL/SQL, Stored Java Procedures, and XML. Run queries, generate execution plans, export data to the desired format (XML, Excel, HTML, PDF, etc.), execute, debug, test, and document your database programs, and much more with SQL Developer.

How do I clone a user in SQL Developer?

Open the Security and Users node and find the user you want to create a clone of and right-click the user and select the "Create Like" option. Hope this helps.

Is SQL Developer the same as Toad?

Toad has a master detail record viewer, SQL Developer does not. Both tools have a query builder, but I feel Toad's is more robust and you can convert the SQL to ANSI joins or regular syntax and appears to do quite a bit more with where clauses, sub queries, and other parts of SQL.

How do I copy and paste in Oracle SQL Developer?

Ctrl or Apple + C for copy, and + V for paste. In SQL Developer if I do this in a grid, I can get my data out onto the clipboard.


1 Answers

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.

like image 199
Todd Pierce Avatar answered Oct 07 '22 18:10

Todd Pierce