Open-ILS/src/sql/Pg/upgrade/YYYY.data.acq_permissions.sql

   1 BEGIN;
   2
   3 INSERT INTO permission.grp_perm_map (grp, perm, depth, grantable)
   4         SELECT
   5                 pgt.id, perm.id, aout.depth, TRUE
   6         FROM
   7                 permission.grp_tree pgt,
   8                 permission.perm_list perm,
   9                 actor.org_unit_type aout
  10         WHERE
  11                 pgt.name = 'Acquisitions Administrator' AND
  12                 aout.name = 'Consortium' AND
  13                 perm.code IN (
  14                     'VIEW_FUND',
  15                     'VIEW_FUNDING_SOURCE',
  16                     'VIEW_FUND_ALLOCATION',
  17                     'VIEW_PICKLIST',
  18                     'VIEW_PROVIDER',
  19                     'VIEW_PURCHASE_ORDER',
  20                     'VIEW_INVOICE',
  21                     'CREATE_PICKLIST',
  22                     'ACQ_ADD_LINEITEM_IDENTIFIER',
  23                     'ACQ_SET_LINEITEM_IDENTIFIER',
  24                     'MANAGE_FUND',
  25                     'CREATE_INVOICE',
  26                     'CREATE_PURCHASE_ORDER',
  27                     'IMPORT_ACQ_LINEITEM_BIB_RECORD',
  28                     'IMPORT_ACQ_LINEITEM_BIB_RECORD_UPLOAD',
  29                     'MANAGE_CLAIM',
  30                     'MANAGE_PROVIDER',
  31                     'MANAGE_FUNDING_SOURCE',
  32                     'RECEIVE_PURCHASE_ORDER',
  33                     'ADMIN_ACQ_LINEITEM_ALERT_TEXT',
  34                     'UPDATE_FUNDING_SOURCE',
  35                     'UPDATE_PROVIDER',
  36                     'VIEW_IMPORT_MATCH_SET',
  37                     'VIEW_MERGE_PROFILE',
  38                     'IMPORT_MARC'
  39                 );
  40
  41
  42 INSERT INTO permission.grp_perm_map (grp, perm, depth, grantable)
  43         SELECT
  44                 pgt.id, perm.id, aout.depth, FALSE
  45         FROM
  46                 permission.grp_tree pgt,
  47                 permission.perm_list perm,
  48                 actor.org_unit_type aout
  49         WHERE
  50                 pgt.name = 'Acquisitions' AND
  51                 aout.name = 'Consortium' AND
  52                 perm.code IN (
  53                     'ACQ_ADD_LINEITEM_IDENTIFIER',
  54                     'ACQ_SET_LINEITEM_IDENTIFIER',
  55                     'ADMIN_ACQ_FUND',
  56                     'ADMIN_FUND',
  57                     'ACQ_INVOICE-REOPEN',
  58                     'ADMIN_ACQ_DISTRIB_FORMULA',
  59                     'ADMIN_INVOICE',
  60                     'IMPORT_ACQ_LINEITEM_BIB_RECORD_UPLOAD',
  61                     'VIEW_IMPORT_MATCH_SET',
  62                     'VIEW_MERGE_PROFILE'
  63                 );
  64
  65 COMMIT;