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

[Fabio Fumi]

Thanks Julien for your suggestions. I don't think I managed to make it work
like that.
Is there anyone who has connected QGIS to an Oracle DB with a proxy user?

Il giorno mar 14 nov 2023 alle ore 08:56 Julien Cabieces <
julien.cabieces at oslandia.com> ha scritto:

>
> In order to set the environment variable, you can follow this procedure
> [0]
>
> Regarding the Oracle client version, It is either oci-19-8 or oci-19-11
> [1], but I would say that both has to work the same way.
>
> [0]
> https://www.howtogeek.com/787217/how-to-edit-environment-variables-on-windows-10-or-11/
> [1] http://download.osgeo.org/osgeo4w/v2/x86_64/release/oci/
>
> Regards,
> Julien
>
>
> > Yes I have also tried using the tnsnames.ora alternative, byut in that
> case I have a doubt about where to set the TNS_ADMIN, in case of a
> > standard Win 11 QGis installation. Could you suggest ? Also, what is the
> Oracle client / version used by QGis? Thanks
> >
> > Il giorno lun 13 nov 2023 alle ore 10:33 Julien Cabieces via QGIS-User <
> qgis-user at lists.osgeo.org> ha scritto:
> >
> >  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
> >  _______________________________________________
> >  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
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20231130/aeb367b7/attachment.htm>