text: DROP VIEW IF EXISTS view_persediaan_barang4_batumandi;
  
  CREATE VIEW view_persediaan_barang4_batumandi AS
  
  SELECT
  *,
  saldo * harga AS jumlah_harga
  
  FROM
  view_persediaan_barang3_batumandi
  
  WHERE
  1 = 1  AND
  saldo > 0 AND
  id_skpd = 32;
  
  
  
  GRANT ALL PRIVILEGES ON view_persediaan_barang4_batumandi TO lap_batumandi;
  REVOKE INSERT, UPDATE, DELETE ON view_persediaan_barang4_batumandi FROM lap_batumandi;
  