Skip to Main Content

#SmartDB Office Hours

Free tips and training every month! Subscribe for reminders and more from Office Hours. FAQ

Header container

August 21, 2018

18:00 UTC   Start Times Around the World

Subscribe to be notified of changes to sessions and give us feedback!

Having trouble watching the video on this page? Open the video in your browser.


CBAC roles, whitelisting, inherit privileges
Bryn Llewelleyn, PL/SQL Product Manager, look closely at three topics that, in his live delivery of his “Guarding Your Data Behind a Hard Shell PL/SQL API” talks, has never had time to address properly: code-based access control (CBAC) via roles, whitelisting via “accessible by”, and “inherit privileges”. These notions are key both to optimal security and to “compiler checked documentation”.

05:00 A concise definition and overview of the SmartDB architecture
25:00 Code-based access control
39:50 Whitelisting with ACCESSIBLE BY
48:30 Inherit privileges

With Q&A liberally sprinkled throughout!

Your Experts



    Toon has been part of the Oracle eco-system since 1987. He is currently a member of Oracle's Real-World Performance team. The RWP-team troubleshoots application performance issues in and around the DBMS. The way applications currently use the DBMS, is often at the root of these performance issues. Prior to joining the RWP team, Toon has been mainly involved in database application development. His special interests are: architecting applications for performance and scalability, database design, and business rules / constraints modeling (see his idea on SQL Assertions here He is a long-time champion of the Smart Database paradigm, i.e. using the database as a processing engine, and not just as a persistence layer.

All Sessions