Thank you all for your feedback. This is great news and I concur with the security risk as our policy is to lock schemas. Professional services had originally told us there was a bug that prevented us from using a separate installation account for Oracle and we had to use schema accounts to connect.
To answer Moushssine's question, we tried awhile back on the jdbc connection, but to be honest, I don't recall what the issue was at the time. We were testing both Oracle and MSSQL during the POC then, had some issues, and ended up having to use basic connectors. I appreciate the community assistance !
------------------------------
Suzanne Lusardi
IT DB Governance & Compliance Analyst
Paychex, Inc.
------------------------------
Original Message:
Sent: 12-04-2019 10:34:42 AM
From: Mouhssine SAIDI
Subject: Oracle 19c schemas without authentication
Hi,
One question, have you tried to use advanced option of connector using jdbc string with proxy user instead of standard connexion mode.
And as Mat. says it's a security issue to use the schema account for profiling/masking, generally we create specific account for this purpose
Regards,
Mouhssine
------------------------------
Mouhssine SAIDI
Community Member
Delphix Community Members
Original Message:
Sent: 12-04-2019 09:23:46 AM
From: Suzanne Lusardi
Subject: Oracle 19c schemas without authentication
We are leveraging new security features of Oracle 19c by building schemas without authentication. What Delphix masking version will support changing connectors to a generic account for Oracle versus relying on schemas to connect for profiling or masking?
------------------------------
Suzanne Lusardi
IT DB Governance & Compliance Analyst
Paychex, Inc.
------------------------------