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

oracle toad oracle-sqldeveloper
Ultimadj picture Ultimadj · Dec 23, 2010 · Viewed 9.7k times · Source

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

Answer

Todd Pierce picture Todd Pierce · Dec 23, 2010

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.

Related questions

Is there a way to find ddl scripts for creating users in Oracle Sql Developer

In Toad, it's easy to look for a ddl script that creates a user with all its grants and roles: In Oracle SQL Developer, I find a similar option but it's not complete: Is there a way to have same …

Read More
ORA-12170: TNS:Connect timeout occurred

I was trying to connect to the database here in my laptop using Oracle Toad but I kept on having this error: ORA-12170: TNS:Connect timeout occurred What are the possible reasons why I kept on having this error? I …

Read More
How can I solve ORA-00911: invalid character error?

I tried to execute an SQL INSERT with Toad for oracle: INSERT INTO GRAT_ACTIVITY (UUID, IP_ADRESS, SEND_MAIL, DATE_CREA, DATE_UPD, CREATOR, CENTER, ETAT, REQUEST) VALUES('555-vgd9-pllkd-5513', '172.12.23.130', 'N', SYSDATE, SYSDATE, '1554', …

Read More