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

    zizu#1985

      Hi,

       

      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

      ERROR:

      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?

       

      Regards,

      Tomasz