ORA-25433: User Does Not Have INHERIT REMOTE PRIVILEGES Privilege On ORDS_PUBLIC_USER
(Doc ID 2926242.1)
Last updated on FEBRUARY 06, 2023
Applies to:
Oracle Application Express (APEX) - Version 21.1 and laterInformation in this document applies to any platform.
Symptoms
On : APEX 21.1 version, Flow Builder
When attempting to use a dblink in a query inside APEX
the following error occurs.
ERROR
-----------------------
ORA-25433: User <parsing_schema> Does Not Have INHERIT REMOTE PRIVILEGES Privilege On Connected User ORDS_PUBLIC_USER
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Import the application that is working on an old DB/APEX version using dblinks.
2. Create the DB link and try to recompile the query that does use it.
Changes
Upgraded the DB to 19c and APEX to 21.X
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 |
References |