What read permissions are needed to read the view?

Question

Oracle

Hello!
Orakle has a QWE schema which has 3 tables, 1 view (named ZXC), 2 packages (P1, P2) and 10 functions (F1,...F10). There is an ASD schema that you have access to.
Objective: to get the ZXC representation data from the ASD sekhma. In this case, the ZXC view uses three tables, and 3 functions from two packages in the QWE schema.
when I execute select count(*) from ZXC
on behalf of QWE - gives 10 results, when on behalf of ASD then 0 results.
The rights are distributed only on reading ZXC.
What rights need to be granted? Or if the problem is not with the rights, then what can be the difficulty?

Answer 1

First, the rights to the functions in the package are not issued. The rights to EXECUTE of a packet are issued.
Secondly, if the request is executed without an error from the ASD user, then everything is OK with the rights.
Thirdly, the difference in the results can be explained by the fact that different parameter values ​​are fed into the representation as input. These include user and system contexts.
I consider it necessary to pay attention that if a pipelined function is used, then it swallows the NO_DATA_FOUND error.