AFTER_LOGON_TRIGGER For Schema Not Working
(Doc ID 2157127.1)
Last updated on JANUARY 13, 2020
Applies to:Oracle Database - Enterprise Edition - Version 184.108.40.206 and later
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Information in this document applies to any platform.
Trigger is not working.
See the The following AFTER_LOGON_TRIGGER for schema "NAMEOFSCHEMA". It does an "EXECUTE IMMEDIATE 'ALTER SESSION SET current_schema=OTHERSCHEMA';"
But the trigger is not working when the user is logged in to that schema enabled using the trigger.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document