Like every year, Trivadis meets for their annual TechEvent. This event is organised twice a year. In Spring as a smaller internal event and in late summer as one of the biggest IT event in Switzerland also for Trivadis customers. Information about the event, the registration and the venue can be found on the website. Agenda is available as PDF.

I will participate in the event with two presentations.

Titel DB, CMU and EUS engineering with vagrant

Scheduled Friday, 12 Sept., 13:45 – 14:30

Abstract Friday afternoon and some free time? Ideal to try Centrally Managed Users (CMU) with AD Integration. Or do you prefer Enterprise User Security (EUS)? Oracle features which place extended demands on the infrastructure can usually not be tested in a company without more. Or who simply has access to an Active Directory, which he can reconfigure for Oracle. Somewhat more complex Security Use Cases can be easily rebuilt in a VM environment. With the help of Vagrant, the setup and construction of an appropriate environment can be automated and greatly simplified. The test AD including Unified Directory and Oracle DB is started with a simple “vagrant up” and is then available for engineering work and testing. In the context of this lecture we will show how such an environment can be created with little effort and adapted to your own needs for cloud or on-premises.

Titel Oracle PDB protection and isolation

Scheduled Friday, 12 Sept., 17:10 – 17:55

Abstract The same principles and measures of database security can be implemented in container databases as in normal single-tenant environments. However, if the container databases are to be used securely by various tenants with more or less high system privileges, additional security measures are required. Especially if access to the operating system is granted directly or indirectly with JVM, external tables, scheduler jobs or directories. The aim of this presentation is to evaluate database security in the focus of container databases and to discuss appropriate measures. This includes the use of lockdown profiles, PDB_OS_CREDENTIALS and various other measures and features. Where useful, the presentation is complemented by appropriate examples and demos. As far as possible, it is also shown how Oracle handles these problems in its cloud solutions (e.g. Autonomous Database).

Hope to see you at the Trivadis TechEvent. Do not hesitate to register.