Posts

Strengthening Database Security with SQL Firewall in Oracle 26ai

Image
  SQL Firewall in Oracle 26ai A hands-on, step-by-step walkthrough for DBAs Why SQL Firewall Matters ▸    Robust mitigation of SQL injection attacks ▸    Zero-trust session context verification ▸    Bypass-proof, kernel-level inspection ▸    Seamless “capture and enforce” lifecycle ▸    Native integration and scalability The 4-Phase Implementation Flow 1️⃣ Enable SQL Firewall    →    2️⃣ Capture Phase    →    3️⃣ Generate Allow-List    →    4️⃣ Enforce Phase   STEP 1   Enable the Global SQL Firewall Turn on SQL Firewall at the database level before any capture or enforcement can begin. SQL Firewall enabled successfully at the global level. STEP 2   Enable Capture Start a capture session for a target user (schema) to record real, in-flight SQL activity: BEGIN   DBMS_SQL_FIREWALL.CREATE_CAPTURE(  ...
Post a Comment
Read more

MySQL Replication on Oracle Cloud’s “Always Free” Compute Instance

Always Free Compute Instance creation on OCI and MySQL Community Server installation Please refer to my previous blog MySQL Installation on Oracle Cloud’s “Always Free” Compute Instance and repeat same step for second instance.In this blog I used one compute Instance as  Master and Other as Slave. MySQL Replication Classic 1.Need to set following System Variable at /etc/my.cnf (Master Host). datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock log-error=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid server_id=1 bind-address=172.0.2.7 master_info_repository=TABLE relay_log_info_repository=TABLE log_bin=master_binlog binlog_format=row Property Value Description server_id 1 On a replication master and each replication slave, you must specify server_id to establish a unique replication ID master_info_repository TABLE The master info log contains status and current configuration informat...
1 comment
Read more