AFTER_LOGON_TRIGGER For Schema Not Working
(Doc ID 2157127.1)
Last updated on AUGUST 04, 2018
Applies to:Oracle Database - Enterprise Edition - Version 18.104.22.168 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!