text: DROP VIEW IF EXISTS view_daftar_barang_awayan;
  
  CREATE VIEW view_daftar_barang_awayan AS
  
  SELECT
  *
  
  FROM
  view_daftar_barang_kabupaten
  
  WHERE
  1 = 1;
  
  
  
  GRANT ALL PRIVILEGES ON view_daftar_barang_awayan TO lap_awayan;
  REVOKE INSERT, UPDATE, DELETE ON view_daftar_barang_awayan FROM lap_awayan;
  DROP VIEW IF EXISTS view_daftar_barang_bappeda;
  
  CREATE VIEW view_daftar_barang_bappeda AS
  
  SELECT
  *
  
  FROM
  view_daftar_barang_kabupaten
  
  WHERE
  1 = 1;
  
  
  
  GRANT ALL PRIVILEGES ON view_daftar_barang_bappeda TO lap_bappeda;
  REVOKE INSERT, UPDATE, DELETE ON view_daftar_barang_bappeda FROM lap_bappeda;
  DROP VIEW IF EXISTS view_daftar_barang_batumandi;
  
  CREATE VIEW view_daftar_barang_batumandi AS
  
  SELECT
  *
  
  FROM
  view_daftar_barang_kabupaten
  
  WHERE
  1 = 1;
  
  
  
  GRANT ALL PRIVILEGES ON view_daftar_barang_batumandi TO lap_batumandi;
  REVOKE INSERT, UPDATE, DELETE ON view_daftar_barang_batumandi FROM lap_batumandi;
  DROP VIEW IF EXISTS view_daftar_barang_batupiring;
  
  CREATE VIEW view_daftar_barang_batupiring AS
  
  SELECT
  *
  
  FROM
  view_daftar_barang_kabupaten
  
  WHERE
  1 = 1;
  
  
  
  GRANT ALL PRIVILEGES ON view_daftar_barang_batupiring TO lap_batupiring;
  REVOKE INSERT, UPDATE, DELETE ON view_daftar_barang_batupiring FROM lap_batupiring;
  DROP VIEW IF EXISTS view_daftar_barang_bkd;
  
  CREATE VIEW view_daftar_barang_bkd AS
  
  SELECT
  *
  
  FROM
  view_daftar_barang_kabupaten
  
  WHERE
  1 = 1;
  
  
  
  GRANT ALL PRIVILEGES ON view_daftar_barang_bkd TO lap_bkd;
  REVOKE INSERT, UPDATE, DELETE ON view_daftar_barang_bkd FROM lap_bkd;
  DROP VIEW IF EXISTS view_daftar_barang_blhk;
  
  CREATE VIEW view_daftar_barang_blhk AS
  
  SELECT
  *
  
  FROM
  view_daftar_barang_kabupaten
  
  WHERE
  1 = 1;
  
  
  
  GRANT ALL PRIVILEGES ON view_daftar_barang_blhk TO lap_blhk;
  REVOKE INSERT, UPDATE, DELETE ON view_daftar_barang_blhk FROM lap_blhk;
  DROP VIEW IF EXISTS view_daftar_barang_bpbd;
  
  CREATE VIEW view_daftar_barang_bpbd AS
  
  SELECT
  *
  
  FROM
  view_daftar_barang_kabupaten
  
  WHERE
  1 = 1;
  
  
  
  GRANT ALL PRIVILEGES ON view_daftar_barang_bpbd TO lap_bpbd;
  REVOKE INSERT, UPDATE, DELETE ON view_daftar_barang_bpbd FROM lap_bpbd;
  DROP VIEW IF EXISTS view_daftar_barang_bpmpd;
  
  CREATE VIEW view_daftar_barang_bpmpd AS
  
  SELECT
  *
  
  FROM
  view_daftar_barang_kabupaten
  
  WHERE
  1 = 1;
  
  
  
  GRANT ALL PRIVILEGES ON view_daftar_barang_bpmpd TO lap_bpmpd;
  REVOKE INSERT, UPDATE, DELETE ON view_daftar_barang_bpmpd FROM lap_bpmpd;
  DROP VIEW IF EXISTS view_daftar_barang_bppakb;
  
  CREATE VIEW view_daftar_barang_bppakb AS
  
  SELECT
  *
  
  FROM
  view_daftar_barang_kabupaten
  
  WHERE
  1 = 1;
  
  
  
  GRANT ALL PRIVILEGES ON view_daftar_barang_bppakb TO lap_bppakb;
  REVOKE INSERT, UPDATE, DELETE ON view_daftar_barang_bppakb FROM lap_bppakb;
  DROP VIEW IF EXISTS view_daftar_barang_bppkp;
  
  CREATE VIEW view_daftar_barang_bppkp AS
  
  SELECT
  *
  
  FROM
  view_daftar_barang_kabupaten
  
  WHERE
  1 = 1;
  
  
  
  GRANT ALL PRIVILEGES ON view_daftar_barang_bppkp TO lap_bppkp;
  REVOKE INSERT, UPDATE, DELETE ON view_daftar_barang_bppkp FROM lap_bppkp;
  DROP VIEW IF EXISTS view_daftar_barang_dinkes;
  
  CREATE VIEW view_daftar_barang_dinkes AS
  
  SELECT
  *
  
  FROM
  view_daftar_barang_kabupaten
  
  WHERE
  1 = 1;
  
  
  
  GRANT ALL PRIVILEGES ON view_daftar_barang_dinkes TO lap_dinkes;
  REVOKE INSERT, UPDATE, DELETE ON view_daftar_barang_dinkes FROM lap_dinkes;
  DROP VIEW IF EXISTS view_daftar_barang_disdik;
  
  CREATE VIEW view_daftar_barang_disdik AS
  
  SELECT
  *
  
  FROM
  view_daftar_barang_kabupaten
  
  WHERE
  1 = 1;
  
  
  
  GRANT ALL PRIVILEGES ON view_daftar_barang_disdik TO lap_disdik;
  REVOKE INSERT, UPDATE, DELETE ON view_daftar_barang_disdik FROM lap_disdik;
  DROP VIEW IF EXISTS view_daftar_barang_dishub;
  
  CREATE VIEW view_daftar_barang_dishub AS
  
  SELECT
  *
  
  FROM
  view_daftar_barang_kabupaten
  
  WHERE
  1 = 1;
  
  
  
  GRANT ALL PRIVILEGES ON view_daftar_barang_dishub TO lap_dishub;
  REVOKE INSERT, UPDATE, DELETE ON view_daftar_barang_dishub FROM lap_dishub;
  DROP VIEW IF EXISTS view_daftar_barang_disporaparbud;
  
  CREATE VIEW view_daftar_barang_disporaparbud AS
  
  SELECT
  *
  
  FROM
  view_daftar_barang_kabupaten
  
  WHERE
  1 = 1;
  
  
  
  GRANT ALL PRIVILEGES ON view_daftar_barang_disporaparbud TO lap_disporaparbud;
  REVOKE INSERT, UPDATE, DELETE ON view_daftar_barang_disporaparbud FROM lap_disporaparbud;
  DROP VIEW IF EXISTS view_daftar_barang_dispu;
  
  CREATE VIEW view_daftar_barang_dispu AS
  
  SELECT
  *
  
  FROM
  view_daftar_barang_kabupaten
  
  WHERE
  1 = 1;
  
  
  
  GRANT ALL PRIVILEGES ON view_daftar_barang_dispu TO lap_dispu;
  REVOKE INSERT, UPDATE, DELETE ON view_daftar_barang_dispu FROM lap_dispu;
  DROP VIEW IF EXISTS view_daftar_barang_distamben;
  
  CREATE VIEW view_daftar_barang_distamben AS
  
  SELECT
  *
  
  FROM
  view_daftar_barang_kabupaten
  
  WHERE
  1 = 1;
  
  
  
  GRANT ALL PRIVILEGES ON view_daftar_barang_distamben TO lap_distamben;
  REVOKE INSERT, UPDATE, DELETE ON view_daftar_barang_distamben FROM lap_distamben;
  DROP VIEW IF EXISTS view_daftar_barang_dppkad;
  
  CREATE VIEW view_daftar_barang_dppkad AS
  
  SELECT
  *
  
  FROM
  view_daftar_barang_kabupaten
  
  WHERE
  1 = 1;
  
  
  
  GRANT ALL PRIVILEGES ON view_daftar_barang_dppkad TO lap_dppkad;
  REVOKE INSERT, UPDATE, DELETE ON view_daftar_barang_dppkad FROM lap_dppkad;
  DROP VIEW IF EXISTS view_daftar_barang_dukcatpil;
  
  CREATE VIEW view_daftar_barang_dukcatpil AS
  
  SELECT
  *
  
  FROM
  view_daftar_barang_kabupaten
  
  WHERE
  1 = 1;
  
  
  
  GRANT ALL PRIVILEGES ON view_daftar_barang_dukcatpil TO lap_dukcatpil;
  REVOKE INSERT, UPDATE, DELETE ON view_daftar_barang_dukcatpil FROM lap_dukcatpil;
  DROP VIEW IF EXISTS view_daftar_barang_halong;
  
  CREATE VIEW view_daftar_barang_halong AS
  
  SELECT
  *
  
  FROM
  view_daftar_barang_kabupaten
  
  WHERE
  1 = 1;
  
  
  
  GRANT ALL PRIVILEGES ON view_daftar_barang_halong TO lap_halong;
  REVOKE INSERT, UPDATE, DELETE ON view_daftar_barang_halong FROM lap_halong;
  DROP VIEW IF EXISTS view_daftar_barang_inspektorat;
  
  CREATE VIEW view_daftar_barang_inspektorat AS
  
  SELECT
  *
  
  FROM
  view_daftar_barang_kabupaten
  
  WHERE
  1 = 1;
  
  
  
  GRANT ALL PRIVILEGES ON view_daftar_barang_inspektorat TO lap_inspektorat;
  REVOKE INSERT, UPDATE, DELETE ON view_daftar_barang_inspektorat FROM lap_inspektorat;
  DROP VIEW IF EXISTS view_daftar_barang_juai;
  
  CREATE VIEW view_daftar_barang_juai AS
  
  SELECT
  *
  
  FROM
  view_daftar_barang_kabupaten
  
  WHERE
  1 = 1;
  
  
  
  GRANT ALL PRIVILEGES ON view_daftar_barang_juai TO lap_juai;
  REVOKE INSERT, UPDATE, DELETE ON view_daftar_barang_juai FROM lap_juai;
  DROP VIEW IF EXISTS view_daftar_barang_kehutanan;
  
  CREATE VIEW view_daftar_barang_kehutanan AS
  
  SELECT
  *
  
  FROM
  view_daftar_barang_kabupaten
  
  WHERE
  1 = 1;
  
  
  
  GRANT ALL PRIVILEGES ON view_daftar_barang_kehutanan TO lap_kehutanan;
  REVOKE INSERT, UPDATE, DELETE ON view_daftar_barang_kehutanan FROM lap_kehutanan;
  DROP VIEW IF EXISTS view_daftar_barang_kesbangpol;
  
  CREATE VIEW view_daftar_barang_kesbangpol AS
  
  SELECT
  *
  
  FROM
  view_daftar_barang_kabupaten
  
  WHERE
  1 = 1;
  
  
  
  GRANT ALL PRIVILEGES ON view_daftar_barang_kesbangpol TO lap_kesbangpol;
  REVOKE INSERT, UPDATE, DELETE ON view_daftar_barang_kesbangpol FROM lap_kesbangpol;
  DROP VIEW IF EXISTS view_daftar_barang_korpri;
  
  CREATE VIEW view_daftar_barang_korpri AS
  
  SELECT
  *
  
  FROM
  view_daftar_barang_kabupaten
  
  WHERE
  1 = 1;
  
  
  
  GRANT ALL PRIVILEGES ON view_daftar_barang_korpri TO lap_korpri;
  REVOKE INSERT, UPDATE, DELETE ON view_daftar_barang_korpri FROM lap_korpri;
  DROP VIEW IF EXISTS view_daftar_barang_kp2tpm;
  
  CREATE VIEW view_daftar_barang_kp2tpm AS
  
  SELECT
  *
  
  FROM
  view_daftar_barang_kabupaten
  
  WHERE
  1 = 1;
  
  
  
  GRANT ALL PRIVILEGES ON view_daftar_barang_kp2tpm TO lap_kp2tpm;
  REVOKE INSERT, UPDATE, DELETE ON view_daftar_barang_kp2tpm FROM lap_kp2tpm;
  DROP VIEW IF EXISTS view_daftar_barang_kpdad;
  
  CREATE VIEW view_daftar_barang_kpdad AS
  
  SELECT
  *
  
  FROM
  view_daftar_barang_kabupaten
  
  WHERE
  1 = 1;
  
  
  
  GRANT ALL PRIVILEGES ON view_daftar_barang_kpdad TO lap_kpdad;
  REVOKE INSERT, UPDATE, DELETE ON view_daftar_barang_kpdad FROM lap_kpdad;
  DROP VIEW IF EXISTS view_daftar_barang_lampihong;
  
  CREATE VIEW view_daftar_barang_lampihong AS
  
  SELECT
  *
  
  FROM
  view_daftar_barang_kabupaten
  
  WHERE
  1 = 1;
  
  
  
  GRANT ALL PRIVILEGES ON view_daftar_barang_lampihong TO lap_lampihong;
  REVOKE INSERT, UPDATE, DELETE ON view_daftar_barang_lampihong FROM lap_lampihong;
  DROP VIEW IF EXISTS view_daftar_barang_paringin;
  
  CREATE VIEW view_daftar_barang_paringin AS
  
  SELECT
  *
  
  FROM
  view_daftar_barang_kabupaten
  
  WHERE
  1 = 1;
  
  
  
  GRANT ALL PRIVILEGES ON view_daftar_barang_paringin TO lap_paringin;
  REVOKE INSERT, UPDATE, DELETE ON view_daftar_barang_paringin FROM lap_paringin;
  DROP VIEW IF EXISTS view_daftar_barang_paringinkota;
  
  CREATE VIEW view_daftar_barang_paringinkota AS
  
  SELECT
  *
  
  FROM
  view_daftar_barang_kabupaten
  
  WHERE
  1 = 1;
  
  
  
  GRANT ALL PRIVILEGES ON view_daftar_barang_paringinkota TO lap_paringinkota;
  REVOKE INSERT, UPDATE, DELETE ON view_daftar_barang_paringinkota FROM lap_paringinkota;
  DROP VIEW IF EXISTS view_daftar_barang_paringinselatan;
  
  CREATE VIEW view_daftar_barang_paringinselatan AS
  
  SELECT
  *
  
  FROM
  view_daftar_barang_kabupaten
  
  WHERE
  1 = 1;
  
  
  
  GRANT ALL PRIVILEGES ON view_daftar_barang_paringinselatan TO lap_paringinselatan;
  REVOKE INSERT, UPDATE, DELETE ON view_daftar_barang_paringinselatan FROM lap_paringinselatan;
  DROP VIEW IF EXISTS view_daftar_barang_paringintimur;
  
  CREATE VIEW view_daftar_barang_paringintimur AS
  
  SELECT
  *
  
  FROM
  view_daftar_barang_kabupaten
  
  WHERE
  1 = 1;
  
  
  
  GRANT ALL PRIVILEGES ON view_daftar_barang_paringintimur TO lap_paringintimur;
  REVOKE INSERT, UPDATE, DELETE ON view_daftar_barang_paringintimur FROM lap_paringintimur;
  DROP VIEW IF EXISTS view_daftar_barang_perindagkop;
  
  CREATE VIEW view_daftar_barang_perindagkop AS
  
  SELECT
  *
  
  FROM
  view_daftar_barang_kabupaten
  
  WHERE
  1 = 1;
  
  
  
  GRANT ALL PRIVILEGES ON view_daftar_barang_perindagkop TO lap_perindagkop;
  REVOKE INSERT, UPDATE, DELETE ON view_daftar_barang_perindagkop FROM lap_perindagkop;
  DROP VIEW IF EXISTS view_daftar_barang_pertanian;
  
  CREATE VIEW view_daftar_barang_pertanian AS
  
  SELECT
  *
  
  FROM
  view_daftar_barang_kabupaten
  
  WHERE
  1 = 1;
  
  
  
  GRANT ALL PRIVILEGES ON view_daftar_barang_pertanian TO lap_pertanian;
  REVOKE INSERT, UPDATE, DELETE ON view_daftar_barang_pertanian FROM lap_pertanian;
  DROP VIEW IF EXISTS view_daftar_barang_rsud;
  
  CREATE VIEW view_daftar_barang_rsud AS
  
  SELECT
  *
  
  FROM
  view_daftar_barang_kabupaten
  
  WHERE
  1 = 1;
  
  
  
  GRANT ALL PRIVILEGES ON view_daftar_barang_rsud TO lap_rsud;
  REVOKE INSERT, UPDATE, DELETE ON view_daftar_barang_rsud FROM lap_rsud;
  DROP VIEW IF EXISTS view_daftar_barang_satpolpp;
  
  CREATE VIEW view_daftar_barang_satpolpp AS
  
  SELECT
  *
  
  FROM
  view_daftar_barang_kabupaten
  
  WHERE
  1 = 1;
  
  
  
  GRANT ALL PRIVILEGES ON view_daftar_barang_satpolpp TO lap_satpolpp;
  REVOKE INSERT, UPDATE, DELETE ON view_daftar_barang_satpolpp FROM lap_satpolpp;
  DROP VIEW IF EXISTS view_daftar_barang_setda;
  
  CREATE VIEW view_daftar_barang_setda AS
  
  SELECT
  *
  
  FROM
  view_daftar_barang_kabupaten
  
  WHERE
  1 = 1;
  
  
  
  GRANT ALL PRIVILEGES ON view_daftar_barang_setda TO lap_setda;
  REVOKE INSERT, UPDATE, DELETE ON view_daftar_barang_setda FROM lap_setda;
  DROP VIEW IF EXISTS view_daftar_barang_setwan;
  
  CREATE VIEW view_daftar_barang_setwan AS
  
  SELECT
  *
  
  FROM
  view_daftar_barang_kabupaten
  
  WHERE
  1 = 1;
  
  
  
  GRANT ALL PRIVILEGES ON view_daftar_barang_setwan TO lap_setwan;
  REVOKE INSERT, UPDATE, DELETE ON view_daftar_barang_setwan FROM lap_setwan;
  DROP VIEW IF EXISTS view_daftar_barang_snt;
  
  CREATE VIEW view_daftar_barang_snt AS
  
  SELECT
  *
  
  FROM
  view_daftar_barang_kabupaten
  
  WHERE
  1 = 1;
  
  
  
  GRANT ALL PRIVILEGES ON view_daftar_barang_snt TO lap_snt;
  REVOKE INSERT, UPDATE, DELETE ON view_daftar_barang_snt FROM lap_snt;
  DROP VIEW IF EXISTS view_daftar_barang_tebingtinggi;
  
  CREATE VIEW view_daftar_barang_tebingtinggi AS
  
  SELECT
  *
  
  FROM
  view_daftar_barang_kabupaten
  
  WHERE
  1 = 1;
  
  
  
  GRANT ALL PRIVILEGES ON view_daftar_barang_tebingtinggi TO lap_tebingtinggi;
  REVOKE INSERT, UPDATE, DELETE ON view_daftar_barang_tebingtinggi FROM lap_tebingtinggi;
  