Database Administration (MOSC)

MOSC Banner

select on view does not returns data

edited Nov 16, 2015 11:07AM in Database Administration (MOSC) 5 commentsAnswered ✓

I have a view that belongs to the user tasy, when I query the view using the user tasy, the query returns 159 rows. I granted the permission to user laboratorio to query the view, using the following code:

grant create session to laboratorio;

grant resource to laboratorio;

GRANT SELECT ON tasy.PRESCR_LABORATORIO_V TO laboratorio;

But when I query the view using a simple " select * from tasy.PRESCR_LABORATORIO_V" the query returns no rows.

I can't find where is the problem.

My oracle version is:

SQL> SELECT * FROM V$VERSION;

BANNER

--------------------------------------------------------------------------------

Oracle Database 11g Release 11.2.0.4.0 - 64bit Production

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