select on view does not returns data
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