From 6a96892860373d681562f005104bec0590ce73ab Mon Sep 17 00:00:00 2001 From: rsoulliere Date: Fri, 3 Jun 2011 13:28:15 -0400 Subject: [PATCH] Add permissions appendix and contribute a function in tools for exporting permissions database in Docbook file. --- 2.0/appendices/permissions.xml | 1944 +++++++++++++++++++++ tools/permissions_to_docbook_function.sql | 105 ++ 2 files changed, 2049 insertions(+) create mode 100644 2.0/appendices/permissions.xml create mode 100644 tools/permissions_to_docbook_function.sql diff --git a/2.0/appendices/permissions.xml b/2.0/appendices/permissions.xml new file mode 100644 index 0000000000..58a324dee1 --- /dev/null +++ b/2.0/appendices/permissions.xml @@ -0,0 +1,1944 @@ + + Permissions List +
+ Permission Descriptions + + + ABORT_REMOTE_TRANSIT + Allow a user to abort a copy transit if the user is not at the transit source or dest + + + ABORT_TRANSIT + Allow a user to abort a copy transit if the user is at the transit destination or source + + + ACQ_XFER_MANUAL_DFUND_AMOUNT + Allow a user to transfer different amounts of money out of one fund and into another + + + actor.org_unit.closed_date.create + Allow a user to create a new closed date for a location + + + actor.org_unit.closed_date.delete + Allow a user to remove a closed date interval for a given location + + + actor.org_unit.closed_date.update + Allow a user to update a closed date interval for a given location + + + ADMIN_ACQ_CANCEL_CAUSE + Allow a user to create/update/delete reasons for order cancellations + + + ADMIN_ACQ_CLAIM + ADMIN_ACQ_CLAIM + + + ADMIN_ACQ_CLAIM_EVENT_TYPE + ADMIN_ACQ_CLAIM_EVENT_TYPE + + + ADMIN_ACQ_CLAIM_TYPE + ADMIN_ACQ_CLAIM_TYPE + + + ADMIN_ACQ_DISTRIB_FORMULA + ADMIN_ACQ_DISTRIB_FORMULA + + + ADMIN_ACQ_FISCAL_YEAR + ADMIN_ACQ_FISCAL_YEAR + + + ADMIN_ACQ_FUND + Allow a user to create/view/update/delete a fund + + + ADMIN_ACQ_FUND_ALLOCATION_PERCENT + ADMIN_ACQ_FUND_ALLOCATION_PERCENT + + + ADMIN_ACQ_FUND_TAG + ADMIN_ACQ_FUND_TAG + + + ADMIN_ACQ_LINEITEM_ALERT_TEXT + ADMIN_ACQ_LINEITEM_ALERT_TEXT + + + ADMIN_AGE_PROTECT_RULE + ADMIN_AGE_PROTECT_RULE + + + ADMIN_ASSET_COPY_TEMPLATE + ADMIN_ASSET_COPY_TEMPLATE + + + ADMIN_BOOKING_RESERVATION + Enables the user to create/update/delete booking reservations + + + ADMIN_BOOKING_RESERVATION_ATTR_MAP + ADMIN_BOOKING_RESERVATION_ATTR_MAP + + + ADMIN_BOOKING_RESERVATION_ATTR_VALUE_MAP + Enables the user to create/update/delete booking reservation attribute value maps + + + ADMIN_BOOKING_RESOURCE + Enables the user to create/update/delete booking resources + + + ADMIN_BOOKING_RESOURCE_ATTR + Enables the user to create/update/delete booking resource attributes + + + ADMIN_BOOKING_RESOURCE_ATTR_MAP + Enables the user to create/update/delete booking resource attribute maps + + + ADMIN_BOOKING_RESOURCE_ATTR_VALUE + Enables the user to create/update/delete booking resource attribute values + + + ADMIN_BOOKING_RESOURCE_TYPE + Enables the user to create/update/delete booking resource types + + + ADMIN_CIRC_MATRIX_MATCHPOINT + ADMIN_CIRC_MATRIX_MATCHPOINT + + + ADMIN_CIRC_MOD + ADMIN_CIRC_MOD + + + ADMIN_CLAIM_POLICY + ADMIN_CLAIM_POLICY + + + ADMIN_CONFIG_REMOTE_ACCOUNT + ADMIN_CONFIG_REMOTE_ACCOUNT + + + ADMIN_COPY_LOCATION_ORDER + Allow a user to create/view/update/delete a copy location order + + + ADMIN_CREDIT_CARD_PROCESSING + Update org unit settings related to credit card processing + + + ADMIN_CURRENCY_TYPE + Allow a user to create/view/update/delete a currency_type + + + ADMIN_FIELD_DOC + ADMIN_FIELD_DOC + + + ADMIN_FUND + Allow a user to create/view/update/delete a fund + + + ADMIN_FUNDING_SOURCE + Allow a user to create/view/update/delete a funding source + + + ADMIN_GLOBAL_FLAG + ADMIN_GLOBAL_FLAG + + + ADMIN_GROUP_PENALTY_THRESHOLD + ADMIN_GROUP_PENALTY_THRESHOLD + + + ADMIN_HOLD_CANCEL_CAUSE + ADMIN_HOLD_CANCEL_CAUSE + + + ADMIN_HOLD_MATRIX_MATCHPOINT + ADMIN_HOLD_MATRIX_MATCHPOINT + + + ADMIN_IDENT_TYPE + ADMIN_IDENT_TYPE + + + ADMIN_IMPORT_ITEM_ATTR_DEF + ADMIN_IMPORT_ITEM_ATTR_DEF + + + ADMIN_INDEX_NORMALIZER + ADMIN_INDEX_NORMALIZER + + + ADMIN_INVOICE + ADMIN_INVOICE + + + ADMIN_INVOICE_METHOD + ADMIN_INVOICE_METHOD + + + ADMIN_INVOICE_PAYMENT_METHOD + ADMIN_INVOICE_PAYMENT_METHOD + + + ADMIN_LINEITEM_MARC_ATTR_DEF + ADMIN_LINEITEM_MARC_ATTR_DEF + + + ADMIN_MARC_CODE + ADMIN_MARC_CODE + + + ADMIN_MAX_FINE_RULE + ADMIN_MAX_FINE_RULE + + + ADMIN_MERGE_PROFILE + ADMIN_MERGE_PROFILE + + + ADMIN_ORG_UNIT_SETTING_TYPE + ADMIN_ORG_UNIT_SETTING_TYPE + + + ADMIN_PROVIDER + Allow a user to create/view/update/delete a provider + + + ADMIN_RECURRING_FINE_RULE + ADMIN_RECURRING_FINE_RULE + + + ADMIN_SERIAL_CAPTION_PATTERN + Create/update/delete serial caption and pattern objects + + + ADMIN_SERIAL_DISTRIBUTION + Create/update/delete serial distribution objects + + + ADMIN_SERIAL_STREAM + Create/update/delete serial stream objects + + + ADMIN_SERIAL_SUBSCRIPTION + Create/update/delete serial subscription objects + + + ADMIN_STANDING_PENALTY + ADMIN_STANDING_PENALTY + + + ADMIN_SURVEY + ADMIN_SURVEY + + + ADMIN_TRIGGER_CLEANUP + Allow a user to create, delete, and update trigger cleanup entries + + + ADMIN_TRIGGER_EVENT_DEF + Allow a user to administer trigger event definitions + + + ADMIN_TRIGGER_HOOK + Allow a user to create, update, and delete trigger hooks + + + ADMIN_TRIGGER_REACTOR + Allow a user to create, update, and delete trigger reactors + + + ADMIN_TRIGGER_TEMPLATE_OUTPUT + Allow a user to delete trigger template output + + + ADMIN_TRIGGER_VALIDATOR + Allow a user to create, update, and delete trigger validators + + + ADMIN_USER_REQUEST_TYPE + ADMIN_USER_REQUEST_TYPE + + + ADMIN_USER_SETTING_GROUP + ADMIN_USER_SETTING_GROUP + + + ADMIN_USER_SETTING_TYPE + ADMIN_USER_SETTING_TYPE + + + ADMIN_Z3950_SOURCE + ADMIN_Z3950_SOURCE + + + ALLOW_ALT_TCN + Allows staff to import a record using an alternate TCN to avoid conflicts + + + ASSIGN_GROUP_PERM + ASSIGN_GROUP_PERM + + + ASSIGN_WORK_ORG_UNIT + Allow a staff member to define where another staff member has their permissions + + + BAR_PATRON + Allow a user to bar a patron + + + CANCEL_HOLDS + Allow a user to cancel holds + + + CAPTURE_RESERVATION + Allows a user to capture booking reservations + + + CHECKIN_BYPASS_HOLD_FULFILL + * no longer applicable + + + CIRC_CLAIMS_RETURNED.override + Allow a user to check in or check out an item that has a status of 'claims returned' + + + CIRC_EXCEEDS_COPY_RANGE.override + Allow staff to override circulation copy range failure + + + CIRC_OVERRIDE_DUE_DATE + Allow a user to change the due date on an item to any date + + + CIRC_PERMIT_OVERRIDE + Allow a user to bypass the circulation permit call for check out + + + COPY_ALERT_MESSAGE.override + Allow a user to check in/out an item that has an alert message + + + COPY_BAD_STATUS.override + Allow a user to check out an item in a non-circulatable status + + + COPY_CHECKIN + Allow a user to check in a copy + + + COPY_CHECKOUT + Allow a user to check out a copy + + + COPY_CIRC_NOT_ALLOWED.override + Allow a user to checkout an item that is marked as non-circ + + + COPY_HOLDS + Allow a user to place a hold on a specific copy + + + COPY_IS_REFERENCE.override + Allow a user to override the copy_is_reference event + + + COPY_NEEDED_FOR_HOLD.override + Allow a user to force renewal of an item that could fulfill a hold request + + + COPY_NOT_AVAILABLE.override + Allow staff to force checkout of Missing/Lost type items + + + COPY_STATUS_LOST.override + Allow a user to remove the lost status from a copy + + + COPY_STATUS_MISSING.override + Allow a user to change the missing status on a copy + + + COPY_TRANSIT_RECEIVE + Allow a user to close out a transit on a copy + + + CREATE_ACQ_FUNDING_SOURCE + CREATE_ACQ_FUNDING_SOURCE + + + CREATE_AUDIENCE + CREATE_AUDIENCE + + + CREATE_AUTHORITY_IMPORT_IMPORT_FIELD_DEF + CREATE_AUTHORITY_IMPORT_IMPORT_FIELD_DEF + + + CREATE_AUTHORITY_IMPORT_QUEUE + CREATE_AUTHORITY_IMPORT_QUEUE + + + CREATE_AUTHORITY_RECORD_NOTE + CREATE_AUTHORITY_RECORD_NOTE + + + CREATE_BIB_BTYPE + CREATE_BIB_BTYPE + + + CREATE_BIB_IMPORT_FIELD_DEF + CREATE_BIB_IMPORT_FIELD_DEF + + + CREATE_BIB_IMPORT_QUEUE + CREATE_BIB_IMPORT_QUEUE + + + CREATE_BIB_LEVEL + CREATE_BIB_LEVEL + + + CREATE_BIBLIO_FINGERPRINT + CREATE_BIBLIO_FINGERPRINT + + + CREATE_BIB_SOURCE + CREATE_BIB_SOURCE + + + CREATE_BILL + Allow a user to create a new bill on a transaction + + + CREATE_BILLING_TYPE + CREATE_BILLING_TYPE + + + CREATE_CIRC_DURATION + CREATE_CIRC_DURATION + + + CREATE_CIRC_MOD + CREATE_CIRC_MOD + + + CREATE_CN_BTYPE + CREATE_CN_BTYPE + + + CREATE_CONTAINER + Allow a user to create a new container for another user + + + CREATE_CONTAINER_ITEM + Allow a user to create a container item for another user + + + CREATE_COPY + Allow a user to create a new copy object + + + CREATE_COPY_BTYPE + CREATE_COPY_BTYPE + + + CREATE_COPY_LOCATION + Allow a user to create a new copy location + + + CREATE_COPY_NOTE + Allow a user to create a new copy note + + + CREATE_COPY_STAT_CAT + User may create a copy statistical category + + + CREATE_COPY_STAT_CAT_ENTRY + User may create an entry in a copy statistical category + + + CREATE_COPY_STAT_CAT_ENTRY_MAP + User may link a copy to an entry in a statistical category + + + CREATE_COPY_STATUS + CREATE_COPY_STATUS + + + CREATE_COPY_TRANSIT + Allow a user to create a transit_copy object for transiting a copy + + + CREATE_DUPLICATE_HOLDS + Allow a user to create duplicate holds (two or more holds on the same title) + + + CREATE_FUND + Allow a user to create a new fund + + + CREATE_FUND_ALLOCATION + Allow a user to create a new fund allocation + + + CREATE_FUNDING_SOURCE + Allow a user to create a new funding source + + + CREATE_HOLD_NOTIFICATION + Allow a user to create new hold notifications + + + CREATE_HOURS_OF_OPERATION + CREATE_HOURS_OF_OPERATION + + + CREATE_IMPORT_ITEM + CREATE_IMPORT_ITEM + + + CREATE_IMPORT_ITEM_ATTR_DEF + CREATE_IMPORT_ITEM_ATTR_DEF + + + CREATE_IMPORT_TRASH_FIELD + CREATE_IMPORT_TRASH_FIELD + + + CREATE_IN_HOUSE_USE + Allow a user to create a new in-house-use + + + CREATE_INVOICE + CREATE_INVOICE + + + CREATE_INVOICE_ITEM_TYPE + CREATE_INVOICE_ITEM_TYPE + + + CREATE_INVOICE_METHOD + CREATE_INVOICE_METHOD + + + CREATE_ITEM_FORM + CREATE_ITEM_FORM + + + CREATE_ITEM_TYPE + CREATE_ITEM_TYPE + + + CREATE_LANGUAGE + CREATE_LANGUAGE + + + CREATE_LASSO + CREATE_LASSO + + + CREATE_LASSO_MAP + CREATE_LASSO_MAP + + + CREATE_LIT_FORM + CREATE_LIT_FORM + + + CREATE_LOCALE + CREATE_LOCALE + + + CREATE_MARC + Allow a user to create new MARC records + + + CREATE_MARC_CODE + CREATE_MARC_CODE + + + CREATE_MERGE_PROFILE + CREATE_MERGE_PROFILE + + + CREATE_METABIB_CLASS + CREATE_METABIB_CLASS + + + CREATE_METABIB_FIELD + CREATE_METABIB_FIELD + + + CREATE_METABIB_SEARCH_ALIAS + CREATE_METABIB_SEARCH_ALIAS + + + CREATE_MFHD_RECORD + Allows a user to create a new MFHD record + + + CREATE_MY_CONTAINER + Allow a user to create a container for themselves + + + CREATE_NET_ACCESS_LEVEL + CREATE_NET_ACCESS_LEVEL + + + CREATE_NON_CAT_TYPE + Allow a user to create a new non-cataloged item type + + + CREATE_ORG_ADDRESS + CREATE_ORG_ADDRESS + + + CREATE_ORG_TYPE + CREATE_ORG_TYPE + + + CREATE_ORG_UNIT + CREATE_ORG_UNIT + + + CREATE_ORG_UNIT_CLOSING + CREATE_ORG_UNIT_CLOSING + + + CREATE_PATRON_STAT_CAT + User may create a new patron statistical category + + + CREATE_PATRON_STAT_CAT_ENTRY + User may create an entry in a patron statistical category + + + CREATE_PATRON_STAT_CAT_ENTRY_MAP + User may link another user to an entry in a statistical category + + + CREATE_PAYMENT + Allow a user to record payments in the Billing Interface + + + CREATE_PERM + CREATE_PERM + + + CREATE_PICKLIST + Allows a user to create a picklist + + + CREATE_PROVIDER + Allow a user to create a new provider + + + CREATE_PURCHASE_ORDER + Allows a user to create a purchase order + + + CREATE_RELEVANCE_ADJUSTMENT + CREATE_RELEVANCE_ADJUSTMENT + + + CREATE_SURVEY + CREATE_SURVEY + + + CREATE_TITLE_NOTE + Allow a user to create a new title note + + + CREATE_TRANSACTION + Allow a user to create a new billable transaction + + + CREATE_TRANSIT + Allow a user to place an item in transit + + + CREATE_TRANSLATION + CREATE_TRANSLATION + + + CREATE_TRIGGER_CLEANUP + Allow a user to create trigger cleanup entries + + + CREATE_TRIGGER_EVENT_DEF + Allow a user to create trigger event definitions + + + CREATE_TRIGGER_HOOK + Allow a user to create trigger hooks + + + CREATE_TRIGGER_REACTOR + Allow a user to create trigger reactors + + + CREATE_TRIGGER_VALIDATOR + Allow a user to create trigger validators + + + CREATE_USER + Allow a user to create another user + + + CREATE_USER_BTYPE + CREATE_USER_BTYPE + + + CREATE_USER_GROUP_LINK + Allow a user to add other users to permission groups + + + CREATE_VOLUME + Allow a user to create a volume + + + CREATE_VOLUME_NOTE + Allow a user to create a new volume note + + + CREATE_VR_FORMAT + CREATE_VR_FORMAT + + + CREATE_XML_TRANSFORM + CREATE_XML_TRANSFORM + + + DELETE_ACQ_FUNDING_SOURCE + DELETE_ACQ_FUNDING_SOURCE + + + DELETE_AUDIENCE + DELETE_AUDIENCE + + + DELETE_AUTHORITY_IMPORT_IMPORT_FIELD_DEF + DELETE_AUTHORITY_IMPORT_IMPORT_FIELD_DEF + + + DELETE_AUTHORITY_IMPORT_QUEUE + DELETE_AUTHORITY_IMPORT_QUEUE + + + DELETE_AUTHORITY_RECORD_NOTE + DELETE_AUTHORITY_RECORD_NOTE + + + DELETE_BIB_BTYPE + DELETE_BIB_BTYPE + + + DELETE_BIB_IMPORT_IMPORT_FIELD_DEF + DELETE_BIB_IMPORT_IMPORT_FIELD_DEF + + + DELETE_BIB_IMPORT_QUEUE + DELETE_BIB_IMPORT_QUEUE + + + DELETE_BIB_LEVEL + DELETE_BIB_LEVEL + + + DELETE_BIBLIO_FINGERPRINT + DELETE_BIBLIO_FINGERPRINT + + + DELETE_BIB_SOURCE + DELETE_BIB_SOURCE + + + DELETE_BILLING_TYPE + DELETE_BILLING_TYPE + + + DELETE_CIRC_DURATION + DELETE_CIRC_DURATION + + + DELETE_CIRC_MOD + DELETE_CIRC_MOD + + + DELETE_CN_BTYPE + DELETE_CN_BTYPE + + + DELETE_CONTAINER + Allow a user to delete another user's container + + + DELETE_CONTAINER_ITEM + Allow a user to delete an item out of another user's container + + + DELETE_COPY + Allow a user to delete a copy + + + DELETE_COPY_BTYPE + DELETE_COPY_BTYPE + + + DELETE_COPY_LOCATION + Allow a user to delete a copy location + + + DELETE_COPY_NOTE + Allow a user to delete another user's copy notes + + + DELETE_COPY_STAT_CAT + User may delete a copy statistical category + + + DELETE_COPY_STAT_CAT_ENTRY + User may delete an entry from a copy statistical category + + + DELETE_COPY_STAT_CAT_ENTRY_MAP + User may delete a copy statistical category entry map + + + DELETE_COPY_STATUS + DELETE_COPY_STATUS + + + DELETE_FUND + Allow a user to delete a fund + + + DELETE_FUND_ALLOCATION + Allow a user to delete a fund allocation + + + DELETE_FUNDING_SOURCE + Allow a user to delete a funding source + + + DELETE_HOLDS + * no longer applicable + + + DELETE_HOURS_OF_OPERATION + DELETE_HOURS_OF_OPERATION + + + DELETE_IMPORT_ITEM + DELETE_IMPORT_ITEM + + + DELETE_IMPORT_ITEM_ATTR_DEF + DELETE_IMPORT_ITEM_ATTR_DEF + + + DELETE_IMPORT_TRASH_FIELD + DELETE_IMPORT_TRASH_FIELD + + + DELETE_INVOICE_ITEM_TYPE + DELETE_INVOICE_ITEM_TYPE + + + DELETE_INVOICE_METHOD + DELETE_INVOICE_METHOD + + + DELETE_ITEM_FORM + DELETE_ITEM_FORM + + + DELETE_ITEM_TYPE + DELETE_ITEM_TYPE + + + DELETE_LANGUAGE + DELETE_LANGUAGE + + + DELETE_LASSO + DELETE_LASSO + + + DELETE_LASSO_MAP + DELETE_LASSO_MAP + + + DELETE_LIT_FORM + DELETE_LIT_FORM + + + DELETE_LOCALE + DELETE_LOCALE + + + DELETE_MARC_CODE + DELETE_MARC_CODE + + + DELETE_MERGE_PROFILE + DELETE_MERGE_PROFILE + + + DELETE_METABIB_CLASS + DELETE_METABIB_CLASS + + + DELETE_METABIB_FIELD + DELETE_METABIB_FIELD + + + DELETE_METABIB_SEARCH_ALIAS + DELETE_METABIB_SEARCH_ALIAS + + + DELETE_MFHD_RECORD + Allows a user to delete an MFHD record + + + DELETE_NET_ACCESS_LEVEL + DELETE_NET_ACCESS_LEVEL + + + DELETE_NON_CAT_TYPE + Allow a user to delete a non cataloged type + + + DELETE_ORG_ADDRESS + DELETE_ORG_ADDRESS + + + DELETE_ORG_TYPE + DELETE_ORG_TYPE + + + DELETE_ORG_UNIT + DELETE_ORG_UNIT + + + DELETE_ORG_UNIT_CLOSING + DELETE_ORG_UNIT_CLOSING + + + DELETE_PATRON_STAT_CAT + User may delete a patron statistical category + + + DELETE_PATRON_STAT_CAT_ENTRY + User may delete an entry from a patron statistical category + + + DELETE_PATRON_STAT_CAT_ENTRY_MAP + User may delete a patron statistical category entry map + + + DELETE_PERM + DELETE_PERM + + + DELETE_PROVIDER + Allow a user to delate a provider + + + DELETE_RECORD + Allow a staff member to directly remove a bibliographic record + + + DELETE_RELEVANCE_ADJUSTMENT + DELETE_RELEVANCE_ADJUSTMENT + + + DELETE_SURVEY + DELETE_SURVEY + + + DELETE_TITLE_NOTE + Allow a user to delete another user's title note + + + DELETE_TRANSIT + DELETE_TRANSIT + + + DELETE_TRANSLATION + DELETE_TRANSLATION + + + DELETE_TRIGGER_CLEANUP + Allow a user to delete trigger cleanup entries + + + DELETE_TRIGGER_EVENT_DEF + Allow a user to delete trigger event definitions + + + DELETE_TRIGGER_HOOK + Allow a user to delete trigger hooks + + + DELETE_TRIGGER_REACTOR + Allow a user to delete trigger reactors + + + DELETE_TRIGGER_TEMPLATE_OUTPUT + Allow a user to delete trigger template output + + + DELETE_TRIGGER_VALIDATOR + Allow a user to delete trigger validators + + + DELETE_USER + Allow a user to mark a user as deleted + + + DELETE_USER_BTYPE + DELETE_USER_BTYPE + + + DELETE_VOLUME + Allow a user to delete a volume + + + DELETE_VOLUME_NOTE + Allow a user to delete another user's volume note + + + DELETE_VR_FORMAT + DELETE_VR_FORMAT + + + DELETE_WORKSTATION + Allow a user to remove an existing workstation so a new one can replace it + + + DELETE_XML_TRANSFORM + DELETE_XML_TRANSFORM + + + GENERAL_ACQ + Lowest level permission required to access the ACQ interface + + + group_application.user + Allow a user to add/remove users to/from the "User" group + + + group_application.user.patron + Allow a user to add/remove users to/from the "Patron" group + + + group_application.user.sip_client + Allow a user to add/remove users to/from the "SIP-Client" group + + + group_application.user.staff + Allow a user to add/remove users to/from the "Staff" group + + + group_application.user.staff.acq + Allows a user to add/remove/edit users in the "ACQ" group + + + group_application.user.staff.acq_admin + Allows a user to add/remove/edit users in the "Acquisitions Administrator" group + + + group_application.user.staff.admin.global_admin + Allow a user to add/remove users to/from the "GlobalAdmin" group + + + group_application.user.staff.admin.lib_manager + Allow a user to add/remove users to/from the "LibraryManager" group + + + group_application.user.staff.admin.local_admin + Allow a user to add/remove users to/from the "LocalAdmin" group + + + group_application.user.staff.cat + Allow a user to add/remove users to/from the "Cataloger" group + + + group_application.user.staff.cat.cat1 + Allow a user to add/remove users to/from the "Cat1" group + + + group_application.user.staff.circ + Allow a user to add/remove users to/from the "Circulator" group + + + group_application.user.staff.supercat + Allow a user to add/remove users to/from the "Supercat" group + + + group_application.user.vendor + Allow a user to add/remove users to/from the "Vendor" group + + + HOLD_EXISTS.override + Allow a user to place multiple holds on a single title + + + HOLD_ITEM_CHECKED_OUT.override + Allows a user to place a hold on an item that they already have checked out + + + HOLD_LOCAL_AVAIL_OVERRIDE + Allow a user to place a hold despite the availability of a local copy + + + IMPORT_ACQ_LINEITEM_BIB_RECORD + Allows a user to import a bib record from the acq staging area (on-order record) into the ILS bib data set + + + IMPORT_MARC + Allow a user to import a MARC record via the Z39.50 interface + + + ISSUANCE_HOLDS + Allow a user to place holds on serials issuances + + + ITEM_AGE_PROTECTED.override + Allow a user to place a hold on an age-protected item + + + ITEM_ON_HOLDS_SHELF.override + Allow staff to override item on holds shelf failure + + + MANAGE_CLAIM + MANAGE_CLAIM + + + MANAGE_FUND + Allow a user to view/credit/debit a fund + + + MANAGE_FUNDING_SOURCE + Allow a user to view/credit/debit a funding source + + + MANAGE_PROVIDER + Allow a user to view and purchase from a provider + + + MARK_BAD_DEBT + Allow a user to mark a transaction as bad (unrecoverable) debt + + + MARK_ITEM_AVAILABLE + Allow a user to mark an item status as 'available' + + + MARK_ITEM_BINDERY + Allow a user to mark an item status as 'bindery' + + + MARK_ITEM_CHECKED_OUT + Allow a user to mark an item status as 'checked out' + + + MARK_ITEM_ILL + Allow a user to mark an item status as 'inter-library loan' + + + MARK_ITEM_IN_PROCESS + Allow a user to mark an item status as 'in process' + + + MARK_ITEM_IN_TRANSIT + Allow a user to mark an item status as 'in transit' + + + MARK_ITEM_LOST + Allow a user to mark an item status as 'lost' + + + MARK_ITEM_MISSING + Allow a user to mark an item status as 'missing' + + + MARK_ITEM_ON_HOLDS_SHELF + Allow a user to mark an item status as 'on holds shelf' + + + MARK_ITEM_ON_ORDER + Allow a user to mark an item status as 'on order' + + + MARK_ITEM_RESHELVING + Allow a user to mark an item status as 'reshelving' + + + MAX_RENEWALS_REACHED.override + Allow a user to renew an item past the maximum renewal count + + + MERGE_AUTH_RECORDS + Allow a user to merge authority records together + + + MERGE_BIB_RECORDS + MERGE_BIB_RECORDS + + + MERGE_USERS + MERGE_USERS + + + money.collections_tracker.create + Allow a user to put someone into collections + + + money.collections_tracker.delete + Allow a user to remove someone from collections + + + MR_HOLDS + Allow a user to create a metarecord holds + + + OFFLINE_EXECUTE + Allow a user to execute an offline script batch + + + OFFLINE_UPLOAD + Allow a user to upload an offline script + + + OFFLINE_VIEW + Allow a user to view uploaded offline script information + + + OPAC_LOGIN + Allow a user to log in to the OPAC + + + OVERRIDE_HOLD_HAS_LOCAL_COPY + Allow a user to override the circ.holds.hold_has_copy_at.block setting + + + PATRON_EXCEEDS_CHECKOUT_COUNT.override + Allow staff to override checkout count failure + + + PATRON_EXCEEDS_FINES.override + Allow staff to override fine amount checkout failure + + + PATRON_EXCEEDS_OVERDUE_COUNT.override + Allow staff to override overdue count failure + + + RECEIVE_PURCHASE_ORDER + Allows a user to mark a purchase order, lineitem, or individual copy as received + + + RECEIVE_SERIAL + Receive serial items + + + REGISTER_WORKSTATION + Allow a user to register a new workstation + + + REMOTE_Z3950_QUERY + Allow a user to perform Z39.50 queries against remote servers + + + REMOVE_GROUP_PERM + REMOVE_GROUP_PERM + + + REMOVE_USER_GROUP_LINK + Allow a user to remove other users from permission groups + + + RENEW_CIRC + Allow a user to renew items + + + RENEW_HOLD_OVERRIDE + Allow a user to continue to renew an item even if it is required for a hold + + + REQUEST_HOLDS + Allow a user to create holds for another user (if true, we still check to make sure they have permission to make the type of hold they are requesting, for example, COPY_HOLDS) + + + REQUEST_HOLDS_OVERRIDE + * no longer applicable + + + RETRIEVE_RESERVATION_PULL_LIST + Allows a user to retrieve a booking reservation pull list + + + RUN_REPORTS + Allow a user to run reports + + + SET_CIRC_CLAIMS_RETURNED + Allow a user to mark an item as 'claims returned' + + + SET_CIRC_CLAIMS_RETURNED.override + Allows staff to override the max claims returned value for a patron + + + SET_CIRC_LOST + Allow a user to mark an item as 'lost' + + + SET_CIRC_MISSING + Allow a user to mark an item as 'missing' + + + SHARE_REPORT_FOLDER + Allow a user to share report his own folders + + + STAFF_LOGIN + Allow a user to log in to the staff client + + + TITLE_HOLDS + Allow a user to place a hold at the title level + + + TRANSIT_COPY + TRANSIT_COPY + + + UNBAR_PATRON + Allow a user to un-bar a patron + + + UPDATE_ACQ_FUNDING_SOURCE + UPDATE_ACQ_FUNDING_SOURCE + + + UPDATE_AUDIENCE + UPDATE_AUDIENCE + + + UPDATE_AUTHORITY_IMPORT_IMPORT_FIELD_DEF + UPDATE_AUTHORITY_IMPORT_IMPORT_FIELD_DEF + + + UPDATE_AUTHORITY_IMPORT_QUEUE + UPDATE_AUTHORITY_IMPORT_QUEUE + + + UPDATE_AUTHORITY_RECORD_NOTE + UPDATE_AUTHORITY_RECORD_NOTE + + + UPDATE_BATCH_COPY + Allow a user to edit copies in batch + + + UPDATE_BIB_BTYPE + UPDATE_BIB_BTYPE + + + UPDATE_BIB_IMPORT_IMPORT_FIELD_DEF + UPDATE_BIB_IMPORT_IMPORT_FIELD_DEF + + + UPDATE_BIB_IMPORT_QUEUE + UPDATE_BIB_IMPORT_QUEUE + + + UPDATE_BIB_LEVEL + UPDATE_BIB_LEVEL + + + UPDATE_BIBLIO_FINGERPRINT + UPDATE_BIBLIO_FINGERPRINT + + + UPDATE_BIB_SOURCE + UPDATE_BIB_SOURCE + + + UPDATE_BILLING_TYPE + UPDATE_BILLING_TYPE + + + UPDATE_BILL_NOTE + Allows staff to edit the note for a bill on a transaction + + + UPDATE_CIRC_DURATION + UPDATE_CIRC_DURATION + + + UPDATE_CIRC_MOD + UPDATE_CIRC_MOD + + + UPDATE_CN_BTYPE + UPDATE_CN_BTYPE + + + UPDATE_CONTAINER + Allow a user to update another user's container + + + UPDATE_COPY + Allow a user to edit a copy + + + UPDATE_COPY_BTYPE + UPDATE_COPY_BTYPE + + + UPDATE_COPY_LOCATION + Allow a user to update a copy location + + + UPDATE_COPY_NOTE + UPDATE_COPY_NOTE + + + UPDATE_COPY_STAT_CAT + User may update a copy statistical category + + + UPDATE_COPY_STAT_CAT_ENTRY + User may update an entry in a copy statistical category + + + UPDATE_COPY_STATUS + UPDATE_COPY_STATUS + + + UPDATE_FUND + Allow a user to update a fund + + + UPDATE_FUND_ALLOCATION + Allow a user to update a fund allocation + + + UPDATE_FUNDING_SOURCE + Allow a user to update a funding source + + + UPDATE_GROUP_PERM + UPDATE_GROUP_PERM + + + UPDATE_HOLD + Allow a user to update another user's hold + + + UPDATE_HOURS_OF_OPERATION + UPDATE_HOURS_OF_OPERATION + + + UPDATE_IMPORT_ITEM + UPDATE_IMPORT_ITEM + + + UPDATE_IMPORT_ITEM_ATTR_DEF + UPDATE_IMPORT_ITEM_ATTR_DEF + + + UPDATE_IMPORT_TRASH_FIELD + UPDATE_IMPORT_TRASH_FIELD + + + UPDATE_INVOICE_ITEM_TYPE + UPDATE_INVOICE_ITEM_TYPE + + + UPDATE_INVOICE_METHOD + UPDATE_INVOICE_METHOD + + + UPDATE_ITEM_FORM + UPDATE_ITEM_FORM + + + UPDATE_ITEM_TYPE + UPDATE_ITEM_TYPE + + + UPDATE_LANGUAGE + UPDATE_LANGUAGE + + + UPDATE_LASSO + UPDATE_LASSO + + + UPDATE_LASSO_MAP + UPDATE_LASSO_MAP + + + UPDATE_LIT_FORM + UPDATE_LIT_FORM + + + UPDATE_LOCALE + UPDATE_LOCALE + + + UPDATE_MARC + Allow a user to edit a MARC record + + + UPDATE_MARC_CODE + UPDATE_MARC_CODE + + + UPDATE_MERGE_PROFILE + UPDATE_MERGE_PROFILE + + + UPDATE_METABIB_CLASS + UPDATE_METABIB_CLASS + + + UPDATE_METABIB_FIELD + UPDATE_METABIB_FIELD + + + UPDATE_METABIB_SEARCH_ALIAS + UPDATE_METABIB_SEARCH_ALIAS + + + UPDATE_MFHD_RECORD + Allows a user to update an MFHD record + + + UPDATE_NET_ACCESS_LEVEL + UPDATE_NET_ACCESS_LEVEL + + + UPDATE_NON_CAT_TYPE + Allow a user to update a non-cataloged item type + + + UPDATE_ORG_ADDRESS + UPDATE_ORG_ADDRESS + + + UPDATE_ORG_SETTING + Allow a user to update an organization unit setting + + + UPDATE_ORG_TYPE + UPDATE_ORG_TYPE + + + UPDATE_ORG_UNIT + Allow a user to change the settings for an organization unit + + + UPDATE_ORG_UNIT_CLOSING + UPDATE_ORG_UNIT_CLOSING + + + UPDATE_ORG_UNIT_SETTING_ALL + UPDATE_ORG_UNIT_SETTING_ALL + + + UPDATE_ORG_UNIT_SETTING.auth.opac_timeout + UPDATE_ORG_UNIT_SETTING.auth.opac_timeout + + + UPDATE_ORG_UNIT_SETTING.auth.staff_timeout + UPDATE_ORG_UNIT_SETTING.auth.staff_timeout + + + UPDATE_ORG_UNIT_SETTING.cat.bib.alert_on_empty + UPDATE_ORG_UNIT_SETTING.cat.bib.alert_on_empty + + + UPDATE_ORG_UNIT_SETTING.cat.bib.keep_on_empty + UPDATE_ORG_UNIT_SETTING.cat.bib.keep_on_empty + + + UPDATE_ORG_UNIT_SETTING.cat.default_item_price + UPDATE_ORG_UNIT_SETTING.cat.default_item_price + + + UPDATE_ORG_UNIT_SETTING.circ.block_renews_for_holds + Allow a user to enable blocking of renews on items that could fulfill holds + + + UPDATE_ORG_UNIT_SETTING.circ.hold_boundary.hard + UPDATE_ORG_UNIT_SETTING.circ.hold_boundary.hard + + + UPDATE_ORG_UNIT_SETTING.circ.hold_boundary.soft + UPDATE_ORG_UNIT_SETTING.circ.hold_boundary.soft + + + UPDATE_ORG_UNIT_SETTING.circ.hold_expire_alert_interval + UPDATE_ORG_UNIT_SETTING.circ.hold_expire_alert_interval + + + UPDATE_ORG_UNIT_SETTING.circ.hold_expire_interval + UPDATE_ORG_UNIT_SETTING.circ.hold_expire_interval + + + UPDATE_ORG_UNIT_SETTING.circ.hold_stalling.soft + UPDATE_ORG_UNIT_SETTING.circ.hold_stalling.soft + + + UPDATE_ORG_UNIT_SETTING.circ.item_checkout_history.max + UPDATE_ORG_UNIT_SETTING.circ.item_checkout_history.max + + + UPDATE_ORG_UNIT_SETTING.circ.lost_materials_processing_fee + UPDATE_ORG_UNIT_SETTING.circ.lost_materials_processing_fee + + + UPDATE_ORG_UNIT_SETTING.circ.reshelving_complete.interval + UPDATE_ORG_UNIT_SETTING.circ.reshelving_complete.interval + + + UPDATE_ORG_UNIT_SETTING.circ.selfcheck.alert_on_checkout_event + UPDATE_ORG_UNIT_SETTING.circ.selfcheck.alert_on_checkout_event + + + UPDATE_ORG_UNIT_SETTING.circ.selfcheck.patron_login_timeout + UPDATE_ORG_UNIT_SETTING.circ.selfcheck.patron_login_timeout + + + UPDATE_ORG_UNIT_SETTING.circ.selfcheck.require_patron_password + UPDATE_ORG_UNIT_SETTING.circ.selfcheck.require_patron_password + + + UPDATE_ORG_UNIT_SETTING.circ.void_overdue_on_lost + UPDATE_ORG_UNIT_SETTING.circ.void_overdue_on_lost + + + UPDATE_ORG_UNIT_SETTING.credit.payments.allow + UPDATE_ORG_UNIT_SETTING.credit.payments.allow + + + UPDATE_ORG_UNIT_SETTING.global.juvenile_age_threshold + UPDATE_ORG_UNIT_SETTING.global.juvenile_age_threshold + + + UPDATE_ORG_UNIT_SETTING.global.password_regex + UPDATE_ORG_UNIT_SETTING.global.password_regex + + + UPDATE_ORG_UNIT_SETTING.opac.barcode_regex + UPDATE_ORG_UNIT_SETTING.opac.barcode_regex + + + UPDATE_ORG_UNIT_SETTING.org.bounced_emails + UPDATE_ORG_UNIT_SETTING.org.bounced_emails + + + UPDATE_ORG_UNIT_SETTING.patron.password.use_phone + UPDATE_ORG_UNIT_SETTING.patron.password.use_phone + + + UPDATE_PATRON_CLAIM_NEVER_CHECKED_OUT_COUNT + Allows staff to manually change a patron's claims never checkout out count + + + UPDATE_PATRON_CLAIM_RETURN_COUNT + Allows staff to manually change a patron's claims returned count + + + UPDATE_PATRON_STAT_CAT + User may update a patron statistical category + + + UPDATE_PATRON_STAT_CAT_ENTRY + User may update an entry in a patron statistical category + + + UPDATE_PAYMENT_NOTE + Allows staff to edit the note for a payment on a transaction + + + UPDATE_PERM + UPDATE_PERM + + + UPDATE_PICKUP_LIB_FROM_HOLDS_SHELF + UPDATE_PICKUP_LIB_FROM_HOLDS_SHELF + + + UPDATE_PICKUP_LIB_FROM_TRANSIT + Allow a user to change the pickup and transit destination for a captured hold item already in transit + + + UPDATE_PROVIDER + Allow a user to update a provider + + + UPDATE_RECORD + Allow a user to update and undelete bibliographic records + + + UPDATE_RELEVANCE_ADJUSTMENT + UPDATE_RELEVANCE_ADJUSTMENT + + + UPDATE_SURVEY + UPDATE_SURVEY + + + UPDATE_TRANSIT + UPDATE_TRANSIT + + + UPDATE_TRANSLATION + UPDATE_TRANSLATION + + + UPDATE_TRIGGER_CLEANUP + Allow a user to update trigger cleanup entries + + + UPDATE_TRIGGER_EVENT_DEF + Allow a user to update trigger event definitions + + + UPDATE_TRIGGER_HOOK + Allow a user to update trigger hooks + + + UPDATE_TRIGGER_REACTOR + Allow a user to update trigger reactors + + + UPDATE_TRIGGER_VALIDATOR + Allow a user to update trigger validators + + + UPDATE_USER + Allow a user to edit a user's record + + + UPDATE_USER_BTYPE + UPDATE_USER_BTYPE + + + UPDATE_VOLUME + Allow a user to edit volumes - needed for merging records. This is a duplicate of VOLUME_UPDATE; user must have both permissions at appropriate level to merge records. + + + UPDATE_VOLUME_NOTE + UPDATE_VOLUME_NOTE + + + UPDATE_VR_FORMAT + UPDATE_VR_FORMAT + + + UPDATE_XML_TRANSFORM + UPDATE_XML_TRANSFORM + + + user_request.create + user_request.create + + + user_request.delete + user_request.delete + + + user_request.update + user_request.update + + + user_request.view + user_request.view + + + VIEW_ACQ_FUND_ALLOCATION_PERCENT + VIEW_ACQ_FUND_ALLOCATION_PERCENT + + + VIEW_ACQ_FUNDING_SOURCE + VIEW_ACQ_FUNDING_SOURCE + + + VIEW_AUTHORITY_RECORD_NOTES + VIEW_AUTHORITY_RECORD_NOTES + + + VIEW_BILLING_TYPE + Allow a user to view billing types + + + VIEW_CIRC_MATRIX_MATCHPOINT + VIEW_CIRC_MATRIX_MATCHPOINT + + + VIEW_CIRCULATIONS + Allow a user to see what another user has checked out + + + VIEW_CLAIM + VIEW_CLAIM + + + VIEW_CONTAINER + Allow a user to view another user's containers (buckets) + + + VIEW_COPY_CHECKOUT_HISTORY + Allow a user to view which users have checked out a given copy + + + VIEW_COPY_NOTES + Allow a user to view all notes attached to a copy + + + VIEW_CREDIT_CARD_PROCESSING + View org unit settings related to credit card processing + + + VIEW_FUND + Allow a user to view a fund + + + VIEW_FUND_ALLOCATION + Allow a user to view a fund allocation + + + VIEW_FUNDING_SOURCE + Allow a user to view a funding source + + + VIEW_GROUP_PENALTY_THRESHOLD + VIEW_GROUP_PENALTY_THRESHOLD + + + VIEW_HOLD + Allow a user to view another user's holds + + + VIEW_HOLD_MATRIX_MATCHPOINT + VIEW_HOLD_MATRIX_MATCHPOINT + + + VIEW_HOLD_NOTIFICATION + Allow a user to view notifications attached to a hold + + + VIEW_HOLD_PERMIT + Allow a user to see if another user has permission to place a hold on a given copy + + + VIEW_INVOICE + VIEW_INVOICE + + + VIEW_MERGE_PROFILE + VIEW_MERGE_PROFILE + + + VIEW_ORG_SETTINGS + Allows a user to view all org settings at the specified level + + + VIEW_PERM_GROUPS + Allow a user to view other users' permission groups + + + VIEW_PERMISSION + Allow a user to view user permissions within the user permissions editor + + + VIEW_PERMIT_CHECKOUT + Allow a user to determine whether another user can check out an item + + + VIEW_PICKLIST + Allow a user to view another users picklist + + + VIEW_PROVIDER + Allow a user to view a provider + + + VIEW_PURCHASE_ORDER + Allows a user to view a purchase order + + + VIEW_REPORT_OUTPUT + Allow a user to view report output + + + VIEW_SERIAL_SUBSCRIPTION + VIEW_SERIAL_SUBSCRIPTION + + + VIEW_STANDING_PENALTY + VIEW_STANDING_PENALTY + + + VIEW_TITLE_NOTES + Allow a user to view all notes attached to a title + + + VIEW_TRANSACTION + Allow a user may view another user's transactions + + + VIEW_TRIGGER_EVENT_DEF + Allow a user to view trigger event definitions + + + VIEW_USER + Allow a user to view another user's Patron Record + + + VIEW_USER_FINES_SUMMARY + Allow a user to view bill details + + + VIEW_USER_TRANSACTIONS + Allow a user to see another user's grocery or circulation transactions in the Bills Interface; duplicate of VIEW_TRANSACTION + + + VIEW_VOLUME_NOTES + Allow a user to view all notes attached to a volume + + + VIEW_ZIP_DATA + Allow a user to query the ZIP code data method + + + VOID_BILLING + Allow a user to void a bill + + + VOLUME_HOLDS + Allow a user to place a volume level hold + + +
+ diff --git a/tools/permissions_to_docbook_function.sql b/tools/permissions_to_docbook_function.sql new file mode 100644 index 0000000000..7d1b716d0d --- /dev/null +++ b/tools/permissions_to_docbook_function.sql @@ -0,0 +1,105 @@ +/* +* Function: permissions_list_to_docbook2() + * Copyright (C) 2011 Robert Soulliere + * This program is free software; you can redistribute it and/or + * modify it under the terms of the GNU General Public License + * as published by the Free Software Foundation; either version 2 + * of the License, or (at your option) any later version. + * + * This program is distributed in the hope that it will be useful, + * but WITHOUT ANY WARRANTY; without even the implied warranty of + * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the + * GNU General Public License for more details. + * + * This function can be used for generating a DocBook appendix in XML format to be included in the Evergreen DocBook documentation. + * It takes the code and descrtiption values from permission.perm_list and formats it into XML. Some cleanup is required to remove added lines in the beginning and end of the file. + * To run this script simple use the following commands from psql: + * \g permissions.xml + * SELECT * FROM permissions_list_to_docbook2(); +*/ + +CREATE OR REPLACE FUNCTION permissions_list_to_docbook2() + RETURNS text AS +$BODY$ +DECLARE + r permission.perm_list; + -- r permission.perm_list; + strXML xml; + strHead text; + strFoot text; + xmlCode xml; + xmlTerm xml; + xmlTermEnd xml; + -- description permission.perm_list.description; +BEGIN + FOR r.code, r.description IN SELECT code, description FROM permission.perm_list AS pl WHERE id > 0 ORDER BY code + LOOP + XMLTerm = XMLCONCAT(XMLTerm, ' + ', + XMLELEMENT (name formalpara, + XMLCONCAT(' + + ', + XMLELEMENT( + name title, + r.code), ' + ', + XMLELEMENT( + name para, + r.description), ' + ' + + ) + ) + ); + + -- XMLTerm = XMLCONCAT(XMLTerm, XMLELEMENT (name listitem, r.description), ' + --'); + END LOOP; + + strXML = XMLELEMENT ( + name appendix, + XMLATTRIBUTES( + 'http://docbook.org/ns/docbook' AS "xmlns", + 'http://www.w3.org/2001/XInclude' AS "xmlns:xi", + 'http://www.w3.org/1999/xlink' AS "xmlns:xl", + '5.0' as version, + 'permissions_appendix' AS "xml:id" + ), + XMLCONCAT( + ' + ', + XMLELEMENT ( + name info, + XMLELEMENT (name title, 'Permissions List') + ), ' + ', + XMLELEMENT ( + name section, + XMLATTRIBUTES( + 'permission_descriptions' AS "xml:id" + ), + XMLCONCAT ( + ' + ', + XMLELEMENT (name title, 'Permission Descriptions'), + ' ', + XMLCONCAT (' + ', XMLTerm, ' + ') + + ), ' + ' + + ) + ), ' +' + ); + RETURN strXML; +END +$BODY$ + LANGUAGE 'plpgsql' VOLATILE + COST 100; + + + -- 2.43.2