Privilages required for generateudf
Hi team,
Im trying to execute the generateudf.sh script and getting the below error.
017-04-06 09:25:50,630 ( OracleUDFJarLoader) WARNING - Encountered database error attempting to load jar into Oracle:
java.sql.SQLSyntaxErrorException: ORA-01031: insufficient privileges
Hi team,
Im trying to execute the generateudf.sh script and getting the below error.
017-04-06 09:25:50,630 ( OracleUDFJarLoader) WARNING - Encountered database error attempting to load jar into Oracle:
java.sql.SQLSyntaxErrorException: ORA-01031: insufficient privileges
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:450)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:399)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1017)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:655)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:249)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:566)
at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:202)
at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:45)
at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:933)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1075)
at oracle.jdbc.driver.OracleStatement.executeUpdateInternal(OracleStatement.java:1640)
at oracle.jdbc.driver.OracleStatement.executeUpdate(OracleStatement.java:1603)
at oracle.jdbc.driver.OracleStatementWrapper.executeUpdate(OracleStatementWrapper.java:308)
at com.pega.pegarules.install.udf.loaders.OracleUDFJarLoader.installJarOnOracle(OracleUDFJarLoader.java:174)
at com.pega.pegarules.install.udf.loaders.OracleUDFJarLoader.load(OracleUDFJarLoader.java:73)
at com.pega.pegarules.install.UDFManager$AbstractUDFExecutor.loadUDFJar(UDFManager.java:348)
at com.pega.pegarules.install.UDFManager$ExecuteUDFWithOutTransaction.executeInner(UDFManager.java:293)
at com.pega.pegarules.install.UDFManager$AbstractUDFExecutor.execute(UDFManager.java:357)
at com.pega.pegarules.install.UDFManager.process(UDFManager.java:178)
at com.pega.pegarules.install.UDFManager.main(UDFManager.java:129)
I hope the df user dosent have appropriate privialge to load jar files. Please correct me if my understanding is wrong.
Could you please let me know what all the privilages required for the database user to execute the generateudf script.
Thanks,
Aruldevan