COMMON_USER_CONNECT lockdown profiles feature in Oracle Database 19c

After upgrading some CDBs to 19c, we hit the problem of not being able to connect as common users to the PDBs. In all affected CDBs, lockdown profiles were in place with following definition regarding common user connection part:

Continue reading “COMMON_USER_CONNECT lockdown profiles feature in Oracle Database 19c”

PDB_OS_CREDENTIAL and PL/SQL external libraries

In the previous blog post I have described PDB_OS_CREDENTIAL initialization parameter and when it can help you in isolating PDBs from each other. Today I’ll show you an example of how it works with PL/SQL external libraries.

Continue reading “PDB_OS_CREDENTIAL and PL/SQL external libraries”
Design a site like this with WordPress.com
Get started