Database Administration (MOSC)

MOSC Banner

not able to see data in the view

edited Feb 6, 2013 8:45AM in Database Administration (MOSC) 4 commentsAnswered
Hi,

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

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