Has anyone tried to do this? The web site says to put the default schema name in square brackets at the end of the connection name. When I try to do that, SQL Developer says that square brackets are illegal characters for a conneciton name.
In essence I want to have users log in with their own individual accounts, but have their schema context automatically set to a different schema.
You'll need to contact the extension provider directly for support.
You could achieve the same result with a trigger - and you'd have more control over when this happened, what applications, etc.
If you want bracketed connection names, you'll need to run an older version of SQL Developer or manually edit the connections.xml file to add the brackets to the name.
Edited by: Jeff Smith SQLDev PM on Apr 24, 2013 10:43 AM
Are you using the latest version of SQL developer? I use this extension and I can create a new connection with the brackets with no error message (v 3.2.20.09), but I do know that I had the issue you're having a few versions back. At that time, I was able to go directly into the connections xml file and put the brackets into the connection name by avoiding the connection rename UI...
Edited by: schillcm on Apr 24, 2013 10:42 AM