ORA-20001: Error In Validation: ORA-01919: Role 'INHERIT ANY PRIVILEGES' Does Not Exist After Upgrading to 12c Database (Doc ID 2121218.1)

Last updated on MARCH 31, 2016

Applies to:

Oracle Application Express (formerly HTML DB) - Version 5.0 to 5.0.3.00.03 [Release 5]
Information in this document applies to any platform.

Symptoms

Problem
----------------

After upgrading to 12c database, utlrp is returning this error:

Error
-----------------

...Database user "SYS", database schema "APEX_050000", user# "1199" 13:56:30
...grant "INHERIT ANY PRIVILEGES" to APEX_050000 13:56:33
ORA-20001: Error in validation: ORA-01919: role 'INHERIT ANY PRIVILEGES' does not exist
ORA-06512: at "SYS.VALIDATE_APEX", line 143
ORA-06512: at "SYS.VALIDATE_APEX",

 

Changes

 Upgraded to 12c Database.

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