My Oracle Support Banner

"SYS As SYSDBA" Is Unable To See A Number Of Records Which Argus Schema owner (ARGUS_APP) Can - Why is this? (Doc ID 1625921.1)

Last updated on DECEMBER 05, 2019

Applies to:

Oracle Argus Safety - Version 7.0.3 and later
Information in this document applies to any platform.


Oracle Argus Safety Version 7.0.3

Attempting to view Argus schema related data from SQL*Plus as SYS DBA account (e.g. selecting records from ARGUS_APP.CASE_EVENT table.

A number of rows that exist in the table are not being displayed (as the SYS user), however these are showing up as the ARGUS_APP (Argus Application Schema Owner)


Execute a query on the ARGUS_APP.CASE_EVENT table as Argus Schema owner and the SYS (as SYSDBA) user, the later does not see all of the records, whilst the former does - why ?


Same count when run as SYS as SYSDBA returns only 166 rows

Able to see all records with Argus Application Schema when setting context, but not SYS as SYSDBA user


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

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