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

Keine Antworten

Du bist nicht angemeldet. Anmelden um eine Antwort zu veröffentlichen.

Eine gute Antwort beantwortet die Frage klar, gibt konstruktives Feedback und fördert die berufliche Weiterentwicklung des Fragenstellers.

Richtlinien für die Beantwortung von Fragen