TransWikia.com

How to create or reusing in python a token based DRCP connection to an Orcale database saving that Token in a Django Model inside postgres

Stack Overflow Asked by ifrh on January 22, 2021

I am trying to figure out how it is possible to use a tokenbased (not username and password) authorization method to create or reuse DRCP connections from one djangobased Python WSGI Webapplication to a remote Oracle database. The token for connecting to that Oracle DB should be stored inside a local postgresql database where all django models of that Web-Application is stored.

I was able to create a "Hello World" Python programm connecting to the Oracle database using user name and password.

Lets have a look to a picture

Connect a Django Web-Application to a remote Oracle database

I found some nice information here:

But the missing link is missing. How to create and use that token for allowing that webapplication from that server to connect to Oracle DB and to some work, without telling the webapplication admin any Oracle DB accounts or asking the current Webapplication for oracle account name and password?

Edit (2020-12-10): perhaps "linked server" is the right way, to do it ?

Add your own answers!

Ask a Question

Get help from others!

© 2024 TransWikia.com. All rights reserved. Sites we Love: PCI Database, UKBizDB, Menu Kuliner, Sharing RPP