3 Replies Latest reply on Oct 26, 2019 6:28 AM by Gaz in Oz

    PDB lockdown profiles - how to check if reason is lockdown profile or not




      I have mulitenant enabled database version 18.7.

      I've created lockdown profile for one of my PDBs in conctainer.

      It prevents lock as common user:


      alter lockdown profile TZ_PROFILE disable feature = ('CONNECTIONS');


      It works correctly, common user cannot logon directly to PDB:


      sqlplus c##tomek/tomek@PDBSRC


      ORA-01017: invalid username/password; logon denied


      Is there any way to check if lockdown profiles prevents some action or not?

      I've tried to search in unified auditing and enable tracing for specific ORA- errors.

      No luck so far?