Gradual Database Password Rollover hands-on Posted on December 28, 2021, updated on December 14, 2021 by Yannick Jaquier Table of contents Preamble Gradual Database Password Rollover testing Continue reading
Secure Oracle application design and the ANY privileges Posted on November 28, 2021, updated on November 23, 2021 by Yannick Jaquier Table of contents Preamble The not so bad solution to avoid CREATE ANY TABLE Oracle proxy user Conclusion References Continue reading
Network encryption hands-on with Java, Python and SQL*Plus Posted on April 26, 2021, updated on April 21, 2021 by Yannick Jaquier Table of contents Preamble Database server configuration for network encryption Activating network encryption with Java Oracle JDBC Thin Driver Oracle JDBC OCI Driver Activating network encryption with Python Conclusion References Continue reading
Privilege Analysis hands-on for least privileges principle Posted on February 25, 2021, updated on January 26, 2021 by Yannick Jaquier Table of contents Preamble Privilege analysis test case Privilege analysis testing Privilege analysis reports and conclusion References Continue reading
Minimum required privileges for PL/SQL debugging with SQL Developer Posted on January 16, 2019, updated on January 16, 2019 by Yannick Jaquier Table of contents Preamble PL/SQL debugging as object owner PL/SQL debugging with another account References Continue reading
Restricting and securing your database network – part 2 Posted on April 13, 2018, updated on February 16, 2021 by Yannick Jaquier Table of contents Preamble Network encryption Network integrity Network strong authentication With orapki With openssl With keytool Securing database network conclusion References Continue reading