VigneshAravind Member since 2007 28 posts
Posted: 4 years ago
Last activity: 3 years 7 months ago

ORA-01749 : you may not GRANT/REVOKE privileges to/from yourself

We were performing the third step of a split schema upgrade (6.2.1 to 7.1.9) "Generate and Apply Rules Schema Objects".

We have received the following error while running the migrate.sh in a Unix + Oracle Setup. Kindly post your suggestions.

[java] 2016-05-03 04:41:34,429 ( SQLLoader) INFO - GRANT ALL ON
[java] 2016-05-03 04:41:34,436 ( SQLLoader) INFO - File: oracledate00550.sql
[java] 2016-05-03 04:41:34,437 ( SQLLoader) INFO - GRANT INSERT ON
[java] 2016-05-03 04:41:34,443 ( SQLLoader) WARNING - Failed to execute SQL in file oracledate00550.sql
[java] java.sql.SQLSyntaxErrorException: ORA-01749: you may not GRANT/REVOKE privileges to/from yourself
[java] at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:445)
[java] at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
[java] at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:879)
[java] at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:450)
[java] at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:192)
[java] at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531)
[java] at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:193)
[java] at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:1033)
[java] at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1329)
[java] at oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:1909)
[java] at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1871)
[java] at oracle.jdbc.driver.OracleStatementWrapper.execute(OracleStatementWrapper.java:318)
[java] at com.pega.pegarules.install.SQLLoader.main(SQLLoader.java:266)
[java] 2016-05-03 04:41:34,445 ( SQLLoader) WARNING - Statement: GRANT insert ON PEGA_APP.pr_sys_updatescache TO pega_user
[java] Exception in thread "main" com.pega.pegarules.install.SQLLoader$SQLLoaderException:
[java] ********************************************************************************
[java] Encountered a SQL Exception, clean schema before running again.
[java] ********************************************************************************
[java] at com.pega.pegarules.install.SQLLoader.fail(SQLLoader.java:359)
[java] at com.pega.pegarules.install.SQLLoader.main(SQLLoader.java:316)

**Moderation Team has archived post**

This post has been archived for educational purposes. Contents and links will no longer be updated. If you have the same/similar question, please write a new post.

Low-Code App Development Upgrades
Moderation Team has archived post
Share this page LinkedIn