not able to see data in the view
I have a 10.2.0.5 database running on AIX. Some of the users trying to fetch datafrom one view and they are getting neither data nor error. But the underlying tables have data and some of the users are able to fetch data from the view they have same privs and roles.
I found one one policy is defined on the view.Please help me how user can see data from this view.
REATE OR REPLACE FORCE VIEW V_DEPS(DIVISION,GROUP_NO,DEPT,DEPT_NAME,PURCHASE_TYPE)ASSELECT GRO.DIVISION DIVISION,DEP.GROUP_NO GROUP_NO,DEP.DEPT DEPT