This project demonstrates a defense-in-depth database security architecture for a Judicial Database Management System (JDMS) using Oracle Database 23ai. It applies Discretionary Access Control (DAC) via Oracle roles, Mandatory Access Control (MAC) via Oracle Label Security (OLS), and Row-level filtering via Virtual Private Database (VPD).

This repository demonstrates the operations associated with Pluggable databases(PDBs). PDB as a popular PL/SQL concept, was executed using technologies of Oracle 21c. This is part of the scholar assignment II of "DB with PL/SQL" AUCA course.

This project covers the installation and configuration of Oracle 18c XE on a Windows 10 virtual machine, including container creation, user and tablespace management, database loading, NLS configuration, and operations on pluggable databases (PDB).