Database Administration (MOSC)

MOSC Banner

system user is enable to read from Editionable view

hello all,

I have been working so long to figure out the issue here.
we have editionable view abc under xyz schema.
when I connected as xyz user and query 
select count(*) from xyz.abc;
 COUNT(*)
----------
        37

however, When I connected as sys or system user and query the same select statement I get 0 rows.
select count(*) from xyz.abc;
  COUNT(*)
----------
         0

I have tried to create a public synonym for the editionable view but still doesn't work.

can anyone help me on 

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center