Write For Us

Why Don't Roles Work in PL/SQL? Lesson 1 of 3

E-Commerce Solutions SEO Solutions Marketing Solutions
205 Views

  • Thanks! Share it with your friends!

    You disliked this video. Thanks for the feedback!

admin
Published
Why Don't Roles Work in PL/SQL? In lesson 1 of this tutorial, Oracle Certified Master DBA John Watson will explain that it is an architectural issue that prevents roles from working in a definer rights stored PL/SQL program (procedure or function). Later, you'll learn that PL/SQL is a statically compiled language and it does not know what roles would be enabled at runtime. So, it is as if SET ROLE NONE were issued - all roles are disabled for the procedure. You will also learn there are alternatives (including Invokers Rights code) and 12c enhancements (control of privilege inheritance and Granting roles to procedures). Visit http://www.skillbuilders.com/why-roles-dont-work-in-plsql for all 3 lessons in this tutorial.
Category
Success
Sign in or sign up to post comments.
Be the first to comment