Interesting - I granted my DBA account proxy access to the APEX_PUBLIC_USER
account. So I proxied to a proxy - that's fantastic.
Except there is no entry (except mine) in PROXY_USERS .... so I guess its a
"special" proxy account?
However, there's nothing in that link about APEX_PUBLIC_USER being a proxy
account specifically and there's no entry in PROXY_USERS for
APEX_PUBLIC_USER.
Chris
On Tue, Apr 2, 2019 at 10:19 AM Andy Klock <andy@xxxxxxxxxxxxxxx> wrote:
On Tue, Apr 2, 2019 at 11:11 AM Chris Taylor <
christopherdtaylor1994@xxxxxxxxx> wrote:
Env:APEX_PUBLIC_USER is an Oracle _proxy_ account.
2. How does APEX_PUBLIC_USER get the necessary rights to the Views if
there are no grants on the views in the database?
Chris Taylor
https://docs.oracle.com/database/121/JJDBC/proxya.htm#JJDBC28352