4 Replies Latest reply on Jan 17, 2018 9:36 AM by Puneet Singh-Oracle

    ORA-01031: insufficient privileges with text search index

    Puneet Singh-Oracle



      We have a PL/SQL procedure which inserts a row in a table which has text index (index_type: domain). When the procedure is called from sqlplus with user account (with execute privilege on that procedure), it works fine.


      However the same procedure when wrapped in REST API call throws following error:-


      ORA-01031: insufficient privileges


      The database also has db vault setup but i'm not sure its causing the issue. Given that ords uses ords_public_user as proxy, does it have anything to do with this issue ?


      Any insights would be very helpful.