Re: APEX_PUBLIC_USER + Library Cache Pin/Library Cache Lock Problem (Grants Mystery too!)

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_at_oracledepot.com> wrote:

>
> On Tue, Apr 2, 2019 at 11:11 AM Chris Taylor <
> christopherdtaylor1994_at_gmail.com> wrote:
>
>> Env:
>> 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
>>
>>
> APEX_PUBLIC_USER is an Oracle _proxy_ account.
>
> https://docs.oracle.com/database/121/JJDBC/proxya.htm#JJDBC28352
>

--
http://www.freelists.org/webpage/oracle-l