PL/SQL (MOSC)

MOSC Banner

the question about roles when executing the stored subprograms

edited Sep 24, 2010 4:39PM in PL/SQL (MOSC) 11 commentsAnswered ✓
 Hi All,

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

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