[Qgis-user] Connecting to Oracle Spatial using a proxy user

[Julien Cabieces]

Hi,

Did you try to use a tnsnames.ora file ?

You can then set the environment variable TNS_ADMIN to point to the
directory which contains the file and then refer to the connexion in
QGIS with the "database name" (dbname in QGIS uri), no host and port
specified.

I have no expertise in configuring the tnsnames.ora file, but when I
have to face complicated connexion, I generally ask for tnsnames.ora and
go this way to make it work.

Regards,
Julien





> Hi,
>
> I have to connect to Oracle DBs for my work with a "proxy" user (security requirements) and I normally make it with SQLDeveloper, setting it up
> like:
>
> username: MY_USER[DB_USER]
> password: << MY_USER password >>
> connection type: Base
> host: << DB host address >>
> port: << DB port >>
> service: << DB service name >>
>
> where MY_USER is my personal user, while DB_USER is the name of the schema where DB tables are present. The DB is an Oracle 12g and is
> v21, but in order to make this work I had to setup SQLDeveloper preferences so to use an external Oracle client (instantclient) and the
> Thick/OCI driver. Also, compatibility with the oracle client needs to be taken care of. I use the Oracle instant client 21.11 and SQLDeveloper
> 21.4.1.
>
> I'm trying to replicate such an Oracle connection in QGIS, but simply setting up the connection details as above, it fails with:
>
> ORA-01017 invalid username/password
>
> I've searched a lot already and tried some variations in the QGIS connection setup, but I haven't been able to solve my problem. Oracle proxy
> user connection doesn't seem to be supported in QGIS, does it?
>
> Can someone here help me?
> thanks in advance
> Fabio
>
> _______________________________________________
> QGIS-User mailing list
> QGIS-User at lists.osgeo.org
> List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user


-- 

Julien Cabieces
Senior Developer at Oslandia
julien.cabieces at oslandia.com