daily pastebin goal
77%
SHARE
TWEET

Untitled

a guest Jun 18th, 2018 66 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. CREATE TABLE public.ppm_morgan_order_consumption
  2. (
  3.     id serial NOT NULL ,
  4.     data jsonb,
  5.     entry_user character varying(20) COLLATE pg_catalog."default" NOT NULL,
  6.     entry_date timestamp without time zone NOT NULL DEFAULT now(),
  7.     CONSTRAINT ppm_morgan_order_consumption_pkey PRIMARY KEY (id)
  8. )
  9. WITH (
  10.     OIDS = FALSE
  11. )
  12. TABLESPACE pg_default;
  13.  
  14. GRANT ALL ON TABLE public.ppm_morgan_order_consumption TO postgres;
  15.  
  16. GRANT INSERT, SELECT, UPDATE, DELETE ON TABLE public.ppm_morgan_order_consumption TO erp_admin;
  17.  
  18. GRANT SELECT ON TABLE public.ppm_morgan_order_consumption TO read;
  19.  
  20. GRANT INSERT, SELECT, UPDATE, DELETE ON TABLE public.ppm_morgan_order_consumption TO itusers;
  21.  
  22. GRANT ALL ON SEQUENCE public.ppm_morgan_order_consumption_id_seq TO postgres;
  23.  
  24. GRANT SELECT, USAGE ON SEQUENCE public.ppm_morgan_order_consumption_id_seq TO erp_admin;
  25.  
  26. GRANT SELECT, USAGE ON SEQUENCE public.ppm_morgan_order_consumption_id_seq TO read;
  27.  
  28. GRANT SELECT, USAGE ON SEQUENCE public.ppm_morgan_order_consumption_id_seq TO itusers;
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top