Oracle connection doesn't use saved username when accessing the same database w/o a saved password

[qgib]

Author Name: Médéric RIBREUX (Médéric RIBREUX)
Original Redmine Issue: 10093
Affected QGIS version: 2.2.0
Redmine category:data_provider/oracle
Assignee: Jürgen Fischer

---

Hello,

I have created multiple connections to my Oracle Spatial repository in QGis, using the Oracle Provider dialog. All of the connections are using the same database but different users. For security reasons, I have chosen to not store the password in the connection parameters.

In that mode, it seems that once you have made a connection with a user, QGis cannot change it, even if you use a different connection where the username is different.

Let's have an example:

1rst connection:

• Name of the connection: TEST_1
• Database: ORACLE_BASE
• Server: ORACLE_SRV
• Username: USER_1
• Save Username: Yes
• Save Password: No

2nd connection:

• Name of the connexion: TEST_2
• Database: ORACLE_BASE
• Server: ORACLE_SRV
• Username: USER_2
• Save Username: Yes
• Save Password: No

I first use the 1st connection (named TEST_1) to open a layer from Oracle server. If I try to use connection TEST_2, QGis doesn't ask for the password and the list of tables is queried using username USER_1 instead of USER_2. It seems the bug is affecting only the username as all of the other options (use metadata, existing geometries, use estimated metadata) are working.

I am not 100% sure that this bug is related to Oracle Provider but this is the first time I have seen such behaviour in QGis database provider dialogs...

[qgib]

Author Name: Jürgen Fischer (@jef-n)

---

• subject was changed from Oracle connexion don't change username when using the same database and password is not saved to Oracle connection don't use saved username when accessing the same database w/o a saved password

[qgib]

Author Name: Jürgen Fischer (@jef-n)

---

• category_id was configured as Data Provider/Oracle

[qgib]

Author Name: Jürgen Fischer (@jef-n)

---

• subject was changed from Oracle connection don't use saved username when accessing the same database w/o a saved password to Oracle connection doesn't use saved username when accessing the same database w/o a saved password

[qgib]

Author Name: Jürgen Fischer (@jef-n)

---

Fixed in changeset "3978bff44709dd251f1739b441a5934f06653011".

---

• status_id was changed from Open to Closed