Solved

PL/SQL: ORA-01031: insufficient privileges

  • 8 April 2024
  • 2 replies
  • 87 views

Badge +3

Hi, im trying to run this plsql block on IEE

DECLARE
  CURSOR CUR_USER_GROUP_USER IS
  SELECT
    USER_GROUP_API.GET_NAME(USER_GROUP_ID) USER_GROUP_NAME, USER_ID, OBJID,
    OBJVERSION
  FROM
    USER_GROUP_USER
  WHERE
    USER_ID = &CF$_IDENTITY;
  INFO_       VARCHAR2(32000);
  OBJID_      VARCHAR2(32000);
  OBJVERSION_ VARCHAR2(32000);
  SWITCH_     VARCHAR2(5) := &CF$_IS_ACTIVE;
  ATTR_       VARCHAR2(32000);
  V_ROWCOUNT  NUMBER;
BEGIN
  NULL;
END;
but i get the error message of the title with no information on what permissions i need
this is the whole error message
 

Server error messages:
3937c6d5-7f86-46fd-b470-b5f7fe7d18d0

Ifs.Fnd.FndSystemException: Unexpected error while calling server method AccessPlsql/Invoke ---> Ifs.Fnd.FndServerFaultException: ORA-06550: line 10, column 12:
PL/SQL: ORA-01031: insufficient privileges

Failed executing statement (ORA-06550: line 10, column 12:
PL/SQL: ORA-01031: insufficient privileges
ORA-06550: line 9, column 3:
PL/SQL: SQL Statement ignored)
   at Ifs.Fnd.AccessProvider.FndConnection.ParseErrorHeader(FndBuffer buffer, FndManualDecisionCollection decisions)
   at Ifs.Fnd.AccessProvider.FndConnection.UnMarshalResponseHeader(Stream responseStream, FndManualDecisionCollection decisions)
   at Ifs.Fnd.AccessProvider.FndConnection.HandleHttpSuccessResult(HttpWebResponse result, FndManualDecisionCollection decisions, String operation, FndBodyType responseBodyType, Object responseBody)
   at Ifs.Fnd.AccessProvider.FndConnection.InvokeInternal(Object requestBody, Object responseBody, String intface, String operation, FndRequestContext requestContext, FndManualDecisionCollection decisions, Boolean forcedSync, Boolean integrationGateway)
   --- End of inner exception stack trace ---
   at Ifs.Fnd.AccessProvider.FndConnection.InvokeInternal(Object requestBody, Object responseBody, String intface, String operation, FndRequestContext requestContext, FndManualDecisionCollection decisions, Boolean forcedSync, Boolean integrationGateway)
   at Ifs.Fnd.AccessProvider.FndConnection.InvokeInternal(String intface, String operation, Object requestBody, Object responseBody, FndRequestContext requestContext, Boolean forcedSync, Boolean integrationGateway)
   at Ifs.Fnd.AccessProvider.PLSQL.FndPLSQLCommandCollection.Invoke()
   at Ifs.Fnd.AccessProvider.PLSQL.FndPLSQLCommand.ExecuteNonQuery()
   at Ifs.Fnd.AccessProvider.PLSQL.FndPLSQLSelectCommandReader.Read(Boolean prepare)
   at Ifs.Fnd.Data.ADONetProvider.FndAPCommand.ExecuteDbDataReader(CommandBehavior behavior)

icon

Best answer by Marcel.Ausan 8 April 2024, 13:09

View original

2 replies

Userlevel 6
Badge +15

@AleMota it’s not much you need to check. Just make sure you have access to:

  • read on DB view: USER_GROUP_USER
  • execute on  USER_GROUP_API.GET_NAME()
Badge +3

@AleMota it’s not much you need to check. Just make sure you have access to:

  • read on DB view: USER_GROUP_USER
  • execute on  USER_GROUP_API.GET_NAME()

Thank you so much, that was it

Reply