My Oracle Support Banner

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

Last updated on AUGUST 05, 2022

Applies to:

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

Symptoms


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

To view full details, sign in with your My Oracle Support account.

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

In this Document
Symptoms
Changes
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.