Stefan Oehrli

soe

Stefan Oehrli

Platform Architect

Trivadis part of Accenture

Biography

Stefan Oehrli is a platform architect and trainer at Trivadis part of Accenture. After studying electrical engineering and a several years of experience as project engineer in the microelectronic and computer science, he began to work with database systems in the late 1998. During this time he could gain substantial experience in physical design, implementation and operation of Oracle databases, define and configure backup & recovery strategies, develop and implement database security strategies or analysis of database performance issues. His main interests include physical database design, backup & recovery, container technologies, database security, database internals and everything else related to the core Oracle database technology. In addition to classes and seminars organised by Trivadis, he regularly lectures at conferences and user group meetings as Oracle ACE. Stefan is the co-author of book "Der Oracle DBA" (Hanser, 2016).

Papers

Security Best Practice: Oracle passwords, but secure!

Event: Connect 2021
Stream: Architecture, Cloud Database & Technology

Authentication is an integral part of database security. If authentication or passwords are insufficient or inadequate, all further security measures are generally useless. But how do you ensure that passwords are complex and authentication is secure? In this presentation, the password hashes will be explained and it will be shown how to make sure passwords and authentication are state of the art. Focusing on the current versions of the Oracle database, the following topics will be discussed: – Oracle database authentication – Password verification and hashes – Where can I find password hashes? – Check and password hashes. – Discussion of various risks related to authentication. – Discussion of password policies and strong passwords. – Customer Use Case in the DB Vault environment "ups we have forgotten the passwords". The presentation will be supplemented by corresponding examples and live demos.

Ready, set, go – DB Sec LAB in 5min

Event: Connect 2021
Stream: Architecture, Cloud Database & Technology

There is always the problem to analyze or the new feature you want to test briefly. But often you lack a corresponding LAB environment.In this presentation, we will show how you can use Infrastructure as Code and Terraform, Vagrant or Docker to quickly and easily create corresponding LAB environments. In doing so, we will show how to create configurations in OCI and on-premises, depending on the use case. Terraform modules, Vagrant configuration, Docker containers as well as a collection of scripts provide the basics to deploy corresponding resources. Enough material to implement your own ideas. The presentation will be complemented by corresponding demos and examples.