[OPEN-ILS-DEV] User permissions error

Robert glibrarysystem at gmail.com
Tue May 27 15:45:14 EDT 2008


Skipped content of type multipart/alternative-------------- next part --------------
evergreen=# select * from permission.grp_tree;
 id |            name            | parent | usergroup | perm_interval |           description               |                application_perm 
----+----------------------------+--------+-----------+---------------+-----------------------------------------+------------------------------------------------
  1 | Users                      |        | f         | 3 years       |                                     | group_application.user
  2 | Patrons                    |      1 | t         | 3 years       |                                     | group_application.user.patron
  3 | Staff                      |      1 | f         | 3 years       |                                     | group_application.user.staff
 10 | Local System Administrator |      3 | t         | 3 years       | System maintenance, configuration, etc. | group_application.user.staff.admin.local_admin
  5 | Circulators                |      3 | t         | 3 years       |                                     | group_application.user.staff
 14 | Circ_Admin                 |      3 | t         | 3 years       | Superuser for Circulation               | group_application.user.staff
  4 | Catalogers                 |      3 | t         | 3 years       |                                     | group_application.user.staff
 15 | Circ2                      |      3 | t         | 3 years       | Circulation                             | group.application.staff.circ2
(8 rows)
-------------- next part --------------
            name            |                      code
  | depth | grantable
----------------------------+-------------------------------------------------+-------+-----------
 Local System Administrator | ABORT_REMOTE_TRANIST
  |     0 | f
 Local System Administrator | ABORT_TRANSIT
  |     0 | f
 Local System Administrator | actor.org_unit.closed_date.create
  |     0 | f
 Local System Administrator | actor.org_unit.closed_date.delete
  |     0 | f
 Local System Administrator | actor.org_unit.closed_date.update
  |     0 | f
 Local System Administrator | ASSIGN_WORK_ORG_UNIT
  |     0 | f
 Local System Administrator | BAR_PATRON
  |     0 | f
 Local System Administrator | CANCEL_HOLDS
:

  |     0 | f
 Staff                      | CHECKIN_BYPASS_HOLD_FULFILL
  |     0 | f
 Local System Administrator | CIRC_CLAIMS_RETURNED.override
  |     0 | f
 Local System Administrator | CIRC_EXCEEDS_COPY_RANGE.override
  |     0 | f
 Local System Administrator | CIRC_OVERRIDE_DUE_DATE
  |     0 | f
 Local System Administrator | CIRC_PERMIT_OVERRIDE
  |     0 | f
 Local System Administrator | COPY_ALERT_MESSAGE.override
  |     0 | f
 Local System Administrator | COPY_BAD_STATUS.override
  |     0 | f
 Users                      | COPY_CHECKIN
  |     0 | f
 Staff                      | COPY_CHECKOUT
  |     0 | f
:
 Staff                      | COPY_HOLDS
  |     1 | f
 Staff                      | COPY_TRANSIT_RECEIVE
  |     0 | f
 Staff                      | CREATE_BILL
  |     0 | f
 Staff                      | CREATE_CONTAINER
  |     0 | f
 Staff                      | CREATE_CONTAINER_ITEM
  |     0 | f
 Staff                      | CREATE_COPY
  |     1 | f
 Staff                      | CREATE_COPY_LOCATION
  |     1 | f
 Staff                      | CREATE_COPY_NOTE
  |     1 | f
 Staff                      | CREATE_COPY_STAT_CAT
  |     1 | f
 Staff                      | CREATE_COPY_STAT_CAT_ENTRY
:
 |     1 | f
 Staff                      | CREATE_COPY_TRANSIT
  |     0 | f
 Staff                      | CREATE_HOLD_NOTIFICATION
  |     0 | f
 Staff                      | CREATE_IN_HOUSE_USE
  |     1 | f
 Staff                      | CREATE_MARC
  |     0 | f
 Patrons                    | CREATE_MY_CONTAINER
  |     0 | f
 Users                      | CREATE_MY_CONTAINER
  |     0 | f
 Staff                      | CREATE_NON_CAT_TYPE
  |     1 | f
 Staff                      | CREATE_PATRON_STAT_CAT
  |     1 | f
 Staff                      | CREATE_PATRON_STAT_CAT_ENTRY
  |     1 | f
:
Staff                      | CREATE_PATRON_STAT_CAT_ENTRY_MAP
  |     0 | f
 Staff                      | CREATE_PAYMENT
  |     0 | f
 Local System Administrator | CREATE_TITLE_NOTE
  |     0 | f
 Staff                      | CREATE_TRANSACTION
  |     0 | f
 Staff                      | CREATE_TRANSIT
  |     0 | f
 Staff                      | CREATE_USER
  |     0 | f
 Local System Administrator | CREATE_USER_GROUP_LINK
  |     1 | f
 Staff                      | CREATE_USER_GROUP_LINK
  |     1 | f
 Staff                      | CREATE_VOLUME
  |     1 | f
 Staff                      | CREATE_VOLUME_NOTE
:
 |     1 | f
 Staff                      | DELETE_CONTAINER
  |     0 | f
 Catalogers                 | DELETE_COPY
  |     0 | f
 Local System Administrator | DELETE_COPY_LOCATION
  |     0 | f
 Local System Administrator | DELETE_COPY_NOTE
  |     0 | f
 Local System Administrator | DELETE_COPY_STAT_CAT
  |     0 | f
 Local System Administrator | DELETE_COPY_STAT_CAT_ENTRY
  |     0 | f
 Local System Administrator | DELETE_COPY_STAT_CAT_ENTRY_MAP
  |     0 | f
 Local System Administrator | DELETE_PATRON_STAT_CAT
  |     0 | f
 Local System Administrator | DELETE_PATRON_STAT_CAT_ENTRY
  |     0 | f
:
 Local System Administrator | DELETE_PATRON_STAT_CAT_ENTRY_MAP
  |     0 | f
 Local System Administrator | DELETE_TITLE_NOTE
  |     0 | f
 Staff                      | DELETE_USER
  |     0 | f
 Staff                      | DELETE_VOLUME
  |     1 | f
 Local System Administrator | DELETE_VOLUME_NOTE
  |     0 | f
 Local System Administrator | DELETE_WORKSTATION
  |     0 | f
 Local System Administrator | EVERYTHING
  |     0 | f
 Local System Administrator | group_application.user
  |     0 | f
 Staff                      | group_application.user
  |     1 | f
 Local System Administrator | group_application.user.patron
:
 |     0 | f
 Staff                      | group_application.user.patron
  |     1 | f
 Local System Administrator | group_application.user.sip_client
  |     0 | f
 Local System Administrator | group_application.user.staff
  |     0 | f
 Staff                      | group_application.user.staff
  |     1 | f
 Local System Administrator | group_application.user.staff.admin.global_admin |     0 | f
 Local System Administrator | group_application.user.staff.admin.lib_manager  |     0 | f
 Local System Administrator | group_application.user.staff.admin.local_admin  |     0 | f
 Local System Administrator | group_application.user.staff.cat
  |     0 | f
 Local System Administrator | group_application.user.staff.cat.cat1
  |     0 | f
:

 Local System Administrator | group_application.user.staff.circ
  |     0 | f
 Local System Administrator | group_application.user.staff.supercat
  |     0 | f
 Local System Administrator | group_application.user.vendor
  |     0 | f
 Staff                      | IMPORT_MARC
  |     0 | f
 Local System Administrator | money.collections_tracker.create
  |     0 | f
 Local System Administrator | money.collections_tracker.delete
  |     0 | f
 Users                      | MR_HOLDS
  |     0 | f
 Local System Administrator | OFFLINE_EXECUTE
  |     0 | t
 Staff                      | OFFLINE_UPLOAD
  |     1 | f
 Staff                      | OFFLINE_VIEW
:
 |     1 | f
 Users                      | OPAC_LOGIN
  |     0 | f
 Staff                      | REGISTER_WORKSTATION
  |     0 | f
 Staff                      | REMOTE_Z3950_QUERY
  |     0 | f
 Patrons                    | RENEW_CIRC
  |     0 | f
 Staff                      | RENEW_CIRC
  |     0 | f
 Staff                      | RENEW_HOLD_OVERRIDE
  |     0 | f
 Staff                      | REQUEST_HOLDS
  |     0 | f
 Local System Administrator | REQUEST_HOLDS_OVERRIDE
  |     0 | f
 Local System Administrator | RUN_REPORTS
  |     0 | f
:
 Staff                      | SET_CIRC_CLAIMS_RETURNED
  |     0 | f
 Staff                      | SET_CIRC_LOST
  |     0 | f
 Staff                      | SET_CIRC_MISSING
  |     0 | f
 Staff                      | STAFF_LOGIN
  |     0 | f
 Users                      | TITLE_HOLDS
  |     0 | f
 Staff                      | UPDATE_BATCH_COPY
  |     1 | f
 Staff                      | UPDATE_CONTAINER
  |     0 | f
 Staff                      | UPDATE_COPY
  |     1 | f
 Staff                      | UPDATE_COPY_LOCATION
  |     1 | f
 Staff                      | UPDATE_COPY_STAT_CAT
:

 |     1 | f
 Staff                      | UPDATE_COPY_STAT_CAT_ENTRY
  |     1 | f
 Staff                      | UPDATE_MARC
  |     0 | f
 Staff                      | UPDATE_NON_CAT_TYPE
  |     1 | f
 Local System Administrator | UPDATE_ORG_SETTING
  |     0 | f
 Staff                      | UPDATE_ORG_UNIT
  |     1 | f
 Staff                      | UPDATE_PATRON_STAT_CAT
  |     1 | f
 Staff                      | UPDATE_PATRON_STAT_CAT_ENTRY
  |     1 | f
 Staff                      | UPDATE_USER
  |     0 | f
 Staff                      | UPDATE_VOLUME
  |     1 | f
:
 Staff                      | VIEW_CIRCULATIONS
  |     0 | f
 Staff                      | VIEW_CONTAINER
  |     0 | f
 Staff                      | VIEW_COPY_CHECKOUT_HISTORY
  |     0 | f
 Staff                      | VIEW_COPY_NOTES
  |     0 | f
 Staff                      | VIEW_HOLD
  |     0 | f
 Staff                      | VIEW_HOLD_NOTIFICATION
  |     0 | f
 Staff                      | VIEW_HOLD_PERMIT
  |     0 | f
 Staff                      | VIEW_PERM_GROUPS
  |     0 | f
 Staff                      | VIEW_PERMISSION
  |     0 | f
 Staff                      | VIEW_PERMIT_CHECKOUT
:

  |     0 | f
 Local System Administrator | VIEW_REPORT_OUTPUT
  |     0 | f
 Staff                      | VIEW_TITLE_NOTES
  |     0 | f
 Staff                      | VIEW_TRANSACTION
  |     0 | f
 Staff                      | VIEW_USER
  |     0 | f
 Staff                      | VIEW_USER_FINES_SUMMARY
  |     0 | f
 Staff                      | VIEW_USER_TRANSACTIONS
  |     0 | f
 Staff                      | VIEW_VOLUME_NOTES
  |     0 | f
 Staff                      | VOLUME_HOLDS
  |     1 | f
(130 rows)
-------------- next part --------------
evergreen=# select * from permission.usr_perm_map;
 id | usr | perm | depth | grantable
----+-----+------+-------+-----------
  1 |   1 |   -1 |     0 | f
(1 row)


More information about the Open-ils-dev mailing list