Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

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

zizu#1985Oct 18 2019 — edited Oct 26 2019

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

Comments
Post Details
Added on Oct 18 2019
3 comments
399 views