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

No Answers

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions