Hi,
as per the title, APEX_REST_PUBLIC_USER does not exist on my always free cloud database, neither does APEX_LISTENER
I created my database as per the blog posts from Dimitri Gielis, I can create Apex applications and run them with no problems.
The Application Express 19.1 installation guide states...
4.6 Configuring Oracle REST Data Services
When configuring RESTful Services in Oracle Application Express, it creates two new database accounts.
APEX_LISTENER - The account used to query RESTful Services definitions stored in Oracle Application Express.APEX_REST_PUBLIC_USER - The account used when calling RESTful Services definitions stored in Oracle Application Express.
But they don't exist in my database.
The installation guide mentions running apex_rest_config.sql using SYS as SYSDBA but "always free" cloud databases don't allow access to SYS
So my question is, would you expect those 2 accounts to exist and if so, how can I create them when I don't have access to the SYS account?
Thanks
Mark