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”Tag: lockdown profiles
How to generate DDLs of existing lockdown profiles
In my last blog post I mentioned that I’ll write a new one on how to generate DDLs to recreate existing lockdown profiles – the time has come :).
Continue reading “How to generate DDLs of existing lockdown profiles”
Change is the only constant... 