"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 JANUARY 03, 2017

Applies to:

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

Symptoms

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)

e.g

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 ?

e.g.


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

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