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
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.
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.
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.
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.
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.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With