Return-Path: X-Original-To: oracle-l@orafaq.com Delivered-To: oracle-l@orafaq.com Received: from turing.freelists.org (turing.freelists.org [206.53.239.180]) by malta2546.startdedicated.com (Postfix) with ESMTPS id 9C7FE100314225 for ; Wed, 27 Nov 2019 11:48:14 +0100 (CET) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 17015218A8; Wed, 27 Nov 2019 05:48:13 -0500 (EST) DKIM-Signature: v=1; a=rsa-sha256; c=simple/simple; d=freelists.org; s=turing; t=1574851693; bh=CshCV/+yq5rbfcgs5D/2LMj3abhlLiLwFHAfFhvQ954=; h=Date:From:To:Subject:Reply-To:List-Help:List-Unsubscribe:List-Id: List-Subscribe:List-Owner:List-post:List-Archive; b=P/MAn41ROK+cbw0L56eLiHNz3BksCAhGIcMMVqwmmtYBSEbvdyYlcFJSANr8DRNck GDDBC/eTZAAe4sQO16IUU510CevONL+CZ/Zz9aktIKwAcWLCmXDnDCptZw6fYUeg+8 jeD4MoZJnbqikyPnSi77NrIAOVr+SUDzwvYSBeMU= X-Virus-Scanned: Debian amavisd-new at turing.freelists.org Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id ZmkJby2z74zP; Wed, 27 Nov 2019 05:48:12 -0500 (EST) Received: from turing.freelists.org (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 463AB21666; Wed, 27 Nov 2019 05:47:29 -0500 (EST) DKIM-Signature: v=1; a=rsa-sha256; c=simple/simple; d=freelists.org; s=turing; t=1574851689; bh=CshCV/+yq5rbfcgs5D/2LMj3abhlLiLwFHAfFhvQ954=; h=Date:From:To:Subject:Reply-To:List-Help:List-Unsubscribe:List-Id: List-Subscribe:List-Owner:List-post:List-Archive; b=hAEGiQRiLNyqyJ6//98Q/dhtCTEuvN31CNvKdkI8zmJEIsxjmh2eJDV7gPlHKcH/D O/gLyjINDFcwDiqEeobcIX01Q9ZLRbR2Sh1jTZQW5s87ukQ7XT91SqJzlhvQkR4how hT/V0b3Tlbmyz54yeIVMaaL+1tGe5QV3D9y4+Ads= Received: with ECARTIS (v1.0.0; list oracle-l); Wed, 27 Nov 2019 05:46:48 -0500 (EST) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id A992421524 for ; Wed, 27 Nov 2019 05:46:47 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id Zp6rLHYI6QFb for ; Wed, 27 Nov 2019 05:46:47 -0500 (EST) Received: from mx0.linux-mitterteich.de (mx0.linux-mitterteich.de [83.243.40.66]) (using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits)) (No client certificate requested) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTPS id 9B2C4210A3 for ; Wed, 27 Nov 2019 05:46:46 -0500 (EST) Received: from alderaan.pdb.internal (alderaan.pdb.internal [192.168.111.1]) by s-lin-gen-mta-001 (Postfix) with ESMTP id 0D4E91F2BF for ; Wed, 27 Nov 2019 11:46:45 +0100 (CET) Received: from localhost (localhost [127.0.0.1]) by alderaan.pdb.internal (Postfix) with ESMTP id EA9E330023B for ; Wed, 27 Nov 2019 11:46:44 +0100 (CET) Received: from alderaan.pdb.internal ([127.0.0.1]) by localhost (alderaan.pdb.internal [127.0.0.1]) (amavisd-new, port 10032) with ESMTP id 508tPcVbYnZK for ; Wed, 27 Nov 2019 11:46:44 +0100 (CET) Received: from localhost (localhost [127.0.0.1]) by alderaan.pdb.internal (Postfix) with ESMTP id 59F1130024B for ; Wed, 27 Nov 2019 11:46:44 +0100 (CET) Received: from alderaan.pdb.internal ([127.0.0.1]) by localhost (alderaan.pdb.internal [127.0.0.1]) (amavisd-new, port 10026) with ESMTP id wgigSMwVb_Yc for ; Wed, 27 Nov 2019 11:46:44 +0100 (CET) Received: from alderaan.pdb.internal (alderaan.pdb.internal [192.168.111.1]) by alderaan.pdb.internal (Postfix) with ESMTP id 2F66330023B for ; Wed, 27 Nov 2019 11:46:44 +0100 (CET) Date: Wed, 27 Nov 2019 11:46:43 +0100 (CET) From: Martin Klier - Performing Databases GmbH To: Oracle-L Freelists Message-ID: <482778067.9139.1574851603956.JavaMail.zimbra@performing-db.com> Subject: Oracle Authentication pw/ssl parallel MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="=_ada22af8-ed9b-4107-a652-6ca1c69c0e3d" Thread-Topic: Oracle Authentication pw/ssl parallel X-archive-position: 75525 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-to: oracle-l-bounce@freelists.org X-original-sender: martin.klier@performing-db.com Precedence: normal Reply-To: martin.klier@performing-db.com List-Help: List-Unsubscribe: List-software: Ecartis version 1.0.0 List-Id: oracle-l X-List-ID: oracle-l List-Subscribe: List-Owner: List-post: List-Archive: X-list: oracle-l --=_ada22af8-ed9b-4107-a652-6ca1c69c0e3d Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit Dear Listers, is there a way to use a DB user with password OR SSL certificates in parallel? Background: We have an app, that connects with a single DB user (end user auth is in the app). Supporters and developers are using the same DB user as the app does, to reproduce issues and solve problems. We'd want a way to change the password for the humans at regular intervals, with no need to touch the application's config. We have the chance to make the app use certificates. But we have no chance, to move the whole "zoo" of people, tools and whatever to using certificates, too. We are running Java 8 and DB 12.1, but I won't exclude an upgrade if it helps on the long term. Any ideas? Many thanks in advance! Martin -- Martin Klier // Performing Databases GmbH Managing Partner // Senior DB Consultant Oracle ACE Director martin.klier@performing-db.com // https://www.performing-databases.com --=_ada22af8-ed9b-4107-a652-6ca1c69c0e3d Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: quoted-printable
Dear Listers,
is there a way to use a DB user with password OR= SSL certificates in parallel?

Background: We have an app, that connects with a single DB us= er (end user auth is in the app). Supporters and developers are using the s= ame DB user as the app does, to reproduce issues and solve problems. We'd w= ant a way to change the password for the humans at regular intervals, with = no need to touch the application's config. We have the chance to make the a= pp use certificates. But we have no chance, to move the whole "zoo" of peop= le, tools and whatever to using certificates, too.

We are running Java = 8 and DB 12.1, but I won't exclude an upgrade if it helps on the long term.=

Any ideas?

Many thanks in advance!
Martin
<= br>
--
Martin Klier // Performing Datab= ases GmbH
Managing Partner // Senior DB Consultant
Oracle ACE Directo= r

martin.klier@performing-db.com // https://www.performing-databases= .com
--=_ada22af8-ed9b-4107-a652-6ca1c69c0e3d-- -- http://www.freelists.org/webpage/oracle-l