[Cassila4Sec]

They build walls, but forget the windows.
The government is too busy bragging about "digital sovereignty" to realize their own database is leaking 506 citizens' NIKs and addresses to the public.
We didn't break in. We just walked past the "Do Not Enter" sign they forgot to install.
Your move.

Source : Data Kependudukan Banjarbaru, Kalimantan Selatan
Count : 506 records
Fields : no, alamat, rt, rw, nama, nik

506 record :
- NIK
- Nama
- Alamat
- RT/RW

If this isn't negligence, what is it?


SAMPLE

DROP TABLE IF EXISTS warga_banjarbaru;

CREATE TABLE warga_banjarbaru (
  no INT PRIMARY KEY,
  alamat TEXT,
  rt VARCHAR(10),
  rw VARCHAR(10),
  nama VARCHAR(150),
  nik VARCHAR(16) NOT NULL,
  INDEX idx_nik (nik),
  INDEX idx_nama (nama)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- Sample 20 baris dari total 474 record
-- Full data: data.sql

INSERT INTO warga_banjarbaru (no, alamat, rt, rw, nama, nik) VALUES
(1, 'JL. A. YANI KM. 22,500', '01', '02', 'GG.KELINCI MISLIANI', '6372046502620002'),
(2, 'JL. A. YANI KM. 22.600 GG. KELINCI', '01', '02', 'USMAN ''', '6372040504790001'),
(3, 'JL. A. YANI KM. 23', '01', '02', 'RAMADANI ''', '6372040808850001'),
(4, 'JL. A. YANI KM. 23 KOMP. SINAR LESTARI', '01', '03', 'GUSTI RIDHANI TAUFIK ''', '6307061501580002'),
(5, 'JL. A. YANI KM. 23,5 GG AL-FAJAR NO. 07', '01', '03', 'MUHAMMAD RAMLAN ''', '6372041011950001'),
(6, 'JL. A. YANI KM. 23,5 GG AL-FAJAR NO. 31', '01', '03', 'AHMAD GAFURI ''', '6303031005600004'),
(7, 'JL. A. YANI KM. 23,6 GG RAHMAT', '01', '03', 'ABIDANA ''', '6372046101700001'),
(8, 'JL. A. YANI KM. 23,6 GG RAHMAT', '01', '03', 'EFFENDI BAIDAWI ''', '6372042908760001'),
(9, 'JL. A. YANI KM. 23,00', '01', '03', 'YUSERAN ''', '6372040707470001'),
(10, 'JL. A. YANI KM. 23,700 GG.', '07', '03', 'AL-HUDA RIDHA IZANI ''', '6306030608920001'),
(11, 'JL. A. YANI KM. 23.700', '01', '03', 'ARDIANSYAH ''', '6307060107880242'),
(12, 'JL. A. YANI KM.21.600 JL SRIWIJAYA', '06', '01', 'NO.1 FAUZI RAHMAN ''', '6371010109760009'),
(13, 'JL. A.', '03', '01', 'YANI KM.22 SYAMSUNAH ''', '6372044307780004'),
(14, 'JL. A. YANI KM.22, 400 CARAKA JAYA', '03', '01', 'I PUTU SUKAWIDANA ''', '6372040410720001'),
(15, 'JL. A.', '01', '04', 'YANI KM.23.700 ARDIAN ''', '6372040104740003'),
(16, 'JL. A. YANI KM.23.900 M. SANDI', '01', '04', 'INDRA PRADATA DP ''', '6372042003980001'),
(17, 'JL.', '03', '01', 'A. YANI SUFIANI ''', '6372041909830001'),
(18, 'JL. CARAKA JAYA GG. FAMILY II', '02', '01', 'SAPIAH ''', '6372045708740002'),
(19, 'JL. CARAKA', '03', '01', 'JAYA RUSTAM EFFENDI ''', '6372042105640002'),
(20, 'JL. CARAKAJAYA GG. FAMILI 1', '02', '01', 'RIZAL HIDAYAT ''', '6372041603920001');

Hidden Content

You must register or login to view this content.

— Cassila4Sec

[brassfox15]

cool, thanks