In SQL Developer, there is no command to create a connection based on an existing connection, and just change some of the connection attributes, like the username and password. Edit->Copy is disabled. So how can this be done?
1 Answer
- Click the green + button in the Connections tab.
- Select the connection to duplicate
- Simply edit the name of the connection. If you follow the steps below, this will not rename the connection, but will create a new one.
- Edit the other connection parameters as required.
- Click Test, and check for a Success message subtly hidden near the bottom left corner of the dialog box.
- Click Connect
Your new connection will now be connected. It's not very intuitive, but it works.