Upgrade to Argus Safety 8.2 Issue - Missing GRANT On SYS.V_$PARAMETER. Also Not Listed In Schema Validation
(Doc ID 2511647.1)
Last updated on AUGUST 14, 2019
Applies to:Oracle Argus Safety - Version 8.2 and later
Information in this document applies to any platform.
On Applications Oracle Argus Safety Version : 8.2
Encountered the issue below during the upgrade process (AS 7.0.5 -> AS 8.2):
ORA-01720: grant option does not exist for 'SYS.V_$PARAMETER'
CREATE OR REPLACE VIEW ARGUS_APP.JOBS_ON_SERVER_VU AS SELECT NAME, VALUE FROM V$PARAMETER WHERE NAME = 'job_queue_processes';
Scripts that failed include:
Issue is two-fold
a) Grant is missing
b) The fact that this grant is missing does not show up in Schema Validation log
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