Advertisement
Guest User

Untitled

a guest
May 17th, 2013
75
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.39 KB | None | 0 0
  1. SELECT lsmb__grant_perms('orders_generate', obj, ptype)
  2. FROM unnest(array['oe'::text, 'orderitems', 'business_unit_oitem']) obj,
  3. unnest(array['SELECT'::text, 'INSERT', 'UPDATE']);
  4.  
  5. vs
  6.  
  7. SELECT lsmb__grant_perms('sales_quotation_create', obj, ptype)
  8. FROM unnest(array['orderitems'::text, 'business_unit_oitem']) obj
  9. CROSS JOIN unnest(array['INSERT'::text, 'UPDATE']) ptype;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement