Upgrade Of ORDS Version 18.104.22.168.1032 Is Failing With ORA-01031: Insufficient Privileges
(Doc ID 2811746.1)
Last updated on FEBRUARY 25, 2022
Applies to:Oracle REST Data Services - Version 21.2 to 21.4
Information in this document applies to any platform.
Error while installing ORDS with non sys (but privileged user) user say "myuser"
The installation of actual ORDS Version 22.214.171.124.1032 is failing with following error, when the installation is done with the dedicated database user "myuser" instead of SYS:
[*** Info: Upgrade version: 126.96.36.199 teamPath: upgrade/188.8.131.52/core/ ]
[*** script: add_grant_privs.sql]
Error starting at line : 2 in command -
grant create view to ORDS_METADATA
Error report -
ORA-01031: insufficient privileges
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