Skip to Main Content

Minimize user privileges while maximizing user capability with PL/SQL and code-based access control

Oracle Database Security Office Hours kicks off 2025 with an exciting presentation tailored for both developers and DBAs, focusing on optimizing user privileges and capabilities through PL/SQL and code-based access control.

Key Topics include:

PL/SQL Security Fundamentals
- Understanding when to use invoker versus definer rights
- Controlling access to specific procedures within packages
- Granting procedure execution without extensive privileges

ACCESSIBLE BY Clause
- Restricting access to PL/SQL units and subprograms
- Implementing fine-grained control over code accessibility

Code Based Access Control (CBAC)
- Attaching database roles to PL/SQL functions, procedures, or packages
- Minimizing explicit user privileges

Presenters
- Chris Saxon: Oracle Developer Advocate
- Richard C. Evans (evil rich): Database Security Product Manager

Benefits
- Learn to maximize user capabilities while minimizing privileges
- Understand how to implement granular access control in PL/SQL
- Discover techniques to enhance database security without compromising functionality

This presentation promises to provide valuable insights into advanced PL/SQL security features, helping attendees create more secure and efficient database applications. Don't miss this opportunity to learn from Oracle experts and enhance your database security skills.

 

Join the Database Security product management team on the second Wednesday of the month at 10:00 am US Central time for Database Security Office hours. We hold these sessions each month to keep you updated on what's new with Oracle Database security. We cover announcements about new features, products, and capabilities followed by a discussion of some technical topic. Each session ends with an opportunity for open Q&A about database security.

Featured Speakers

  • Speaker

    Richard Evans

    Oracle
    Product Manager, Database Security

  • Speaker

    Chris Saxon


    Oracle Developer Advocate for SQL

Workshop Info

Session Has Completed - 08 January 2025
1 Hour
English
Database Security

Other Upcoming Sessions