case-sensitive passwords on DB links

Worker

Member³
I have a DB user with a case-sensitive password (on Oracle 11g, which has introduced case-sensitive passwords by default). I have created a database link to connect as that user, using double quotes around the password to keep the case-sensitivity. That all works.

Using "View SQL" for that database link shows the password in the correct case, but omits the double quotes around it. This means the SQL won't create the correct DB link.
 
Back
Top