Skip to Main Content

ORDS, SODA & JSON in the Database

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Getting ORA-01031: insufficient privileges when trying to run ords.enable_schema

Mark Sta AnaJun 6 2017 — edited Jun 7 2017

I've been able to get ORDS standalone (connected to Database A) running locally via SQL Developer. I'm now trying to install it (connected to Database B) using instructions provided by Tim Hall's excellent resource: https://oracle-base.com/articles/misc/oracle-rest-data-services-ords-standalone-mode

I've also checked the install against the following instructions: Installing Oracle REST Data Services

When I try to enable rest service for a schema on Database B. I get the following error.

So far the only difference I can tell between this install and the ORDS install for Database A  is my chosen schema has a proxied user to ORDS_PUBLIC_USER. So I tried to mimic this on Database B using alter user my_schema grant connect through ORDS_PUBLIC_USER;

I've run java -jar ords.war validate and can see no errors in the log.

I even tried create an admin user java -jar ords.war user adminlistener "Listener Administrator" so I could use the REST Data Services > Admininistration feature. I've connected to the ORDS on Database B, but when I right click on Database B in the Connections panel there's no Enable REST services.

Comments

Processing
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jul 5 2017
Added on Jun 6 2017
4 comments
1,606 views