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;
however, When I connected as sys or system user and query the same select statement I get 0 rows.
select count(*) from xyz.abc;
can anyone help me on
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.
I have tried to create a public synonym for the editionable view but still doesn't work.
can anyone help me on
0