The past few days have been an exciting time for Oracle database enthusiasts across Switzerland. The Swiss Oracle User Group (SOUG) organized two fantastic events: the larger SOUG Day in Zurich on September 20th, 2024, and a more intimate gathering in French-speaking Switzerland on September 24th, 2024. Both events attracted Oracle professionals from across the country, who came together to discuss the latest advancements in Oracle database security. I had the privilege of presenting on two key topics: the Oracle 23c SQL Firewall and innovative ideas on using AI to enhance database security.
SOUG Day Zürich: Oracle 23c SQL Firewall, here we go
Oracle SQL Firewall is a recent addition to Oracle’s security toolkit, offering a new approach to database security. In this presentation, I introduced its rule-based data protection features, which give an extra layer of security within the database. The session included demonstrations and practical insights into how the SQL Firewall operates.
Highlights:
- Introduction to Oracle 23c SQL Firewall and its unique rule-based protection
- Demonstrations of SQL Firewall’s functionality in securing user data
- Best practices for integrating SQL Firewall into broader security strategies
- Practical examples showing how SQL Firewall enhances security beyond traditional external database firewalls
You can find the slides from the presentation here. More information about this SOUG event, including the agenda and slides, is available in the SOUG event archive.
SOUG Day Romandie: Oracle DB Security with the Use of AI
In this session, I explored how AI, specifically GenAI and Natural Query Language Prompts, could be used as potential tools for evaluating Unified Audit data and other security-related information in Oracle databases. The presentation focused on the early stages of applying AI to database security, highlighting some new and promising approaches. While these techniques are still in development, they offer a solid starting point for improving security in cloud-based databases.
Highlights:
- Introduction to AI-driven techniques as a first test for evaluating Unified Audit data and other security-related information in Oracle databases
- Demo of how GenAI and Natural Query Language Prompts could streamline security reporting
- Insights into the future potential of AI in Oracle database security
- A live prototype demonstration of AI integration for analyzing database security
You can access the slides for this session here. More information about this SOUG event, including the agenda and slides, is available in the SOUG event archive.
Event Photos
Looking Ahead
Both events provided a valuable opportunity to connect with the Oracle community, exchange ideas, and explore the future of database technology. AI and the SQL Firewall introduce innovative approaches to data protection and analysis. While AI is still in its early stages, it shows great promise. I’m looking ahead to seeing how these technologies develop in the coming years.
If you missed the events, you can access the full agenda and presentation slides via the links above.