rdsadmin_run_apex_rest_config procedure not working

0

Hello to everyone, I have a problem with RDS apex rest configuration procedure: to configure RESTful services in APEX 20.2.v1 I use SQL Plus to connect to the DB instance as “master user”, and then I run the rdsadmin.rdsadmin_run_apex_rest_config stored procedure providing the users password:

SQL> exec rdsadmin.rdsadmin_run_apex_rest_config('apex_listener_password','apex_rest_public_user_password');

This procedure runs the apex_rest_config.sql script, to create a new database accounts for these users and it works fine.

If I run a test of restfull service, I get errors “inexistent table or view” due to the fact the procedure above doesn’t create synonyms.

APEX is installed in the EC2 Container and, as suggests by the AWS guide, I’ve configured ORDS giving “all grant” to the master user.

Now I solved downloading apex package and running apex_rest_config.sql from SQL Plus despite I get a permission error and I’m not sure if everything is working fine.

Did someone get the same issue with apex_rest_config on RDS?

Thankyou

posta 2 anni fa59 visualizzazioni
Nessuna risposta

Accesso non effettuato. Accedi per postare una risposta.

Una buona risposta soddisfa chiaramente la domanda, fornisce un feedback costruttivo e incoraggia la crescita professionale del richiedente.

Linee guida per rispondere alle domande