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

      Hi,

       

      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.

       

      Thanks,

      Puneet