My Oracle Support Banner

ORA-01031 While Trying To Authenticate The Restful Services With Basic Authentication On The Database 18c And Higher (Doc ID 2636529.1)

Last updated on FEBRUARY 12, 2020

Applies to:

Oracle REST Data Services - Version 19.1 to 19.4
Information in this document applies to any platform.


When attempting to authenticate the Restful Service with the Basic Authentication, the following error occurs.

Error Msg = ORA-00604: error occurred at recursive SQL level 1
ORA-01031: insufficient privileges

The issue appearing with the database versions 18c and 19c and the same is working fine over the version 12.2.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.