SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

PL/SQL difference direct granted object privileges, or via role

DoublethinkMar 27 2009 — edited Mar 27 2009

Hello,
"PL/SQL respect object privileges given directly to the user, but does not observe privileges given through roles."
Can someone explain this behaviour ? Why plsql doesn't take roles into account ?

Thanks alot

This post has been answered by 153119 on Mar 27 2009

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 24 2009

Added on Mar 27 2009

5 comments

788 views