Logon trigger doesn't fire - but only when compiling PL-SQL

Hi,

So I am working within a new setup where we have a sandbox database in place for users to perform data science work. They are able to create a private DB link to a second Oracle database where they have a limited read-only account.

Their account on the second database has a logon trigger enabled that sets a default schema. The trigger fires and works exactly as expected when used as a DB link, but only when people are running ad-hoc queries. Whenever someone attempts to compile a function/procedure/package in the sandbox database using their DB link, they see the "table or view not found" error.