Ces_setup Log File Reports Multiple "ORA-01927: cannot REVOKE privileges you did not grant" (Doc ID 2173763.1)

Last updated on AUGUST 18, 2016

Applies to:

Oracle Utilities Network Management System - Version 1.12.0.3 and later
Information in this document applies to any platform.

Symptoms

On : 1.12.0.3 version installation

ces_setup REVOKE privileges / SYNONYM issue

After installation of 1.12.0.3.x on a new server,  we see the following errors in ces_setup log.

SQL> SQL> problem: REVOKE SELECT ON OPAL_CES.TEMP_NCGS FROM CES_RO
ORA-01927: cannot REVOKE privileges you did not grant
problem: REVOKE SELECT ON OPAL_CES.TEMP_NCGS FROM CES_RO
ORA-01927: cannot REVOKE privileges you did not grant
problem: REVOKE SELECT ON OPAL_CES.TEMP_NCGS FROM CES_RO
ORA-01927: cannot REVOKE privileges you did not grant





Changes

 This is a new system.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms