the question about roles when executing the stored subprograms
Assume one user named A with role A_ROLE.
I grant all proper privileges on one of stored procedures named P1 in my schema to A_ROLE.
And I find A can execute P1 correctly and the log utility tells me that the active roles at execution time is 0.
The result complies with books of Tom Kyte and other Oracle experts.
But my question is since I granted to A via role A_ROLE instead of directly, why A still can run my SP?
Thank you very much
Leon