Skip to main content
ExLibris

Knowledge Assistant

BETA
  • Subscribe by RSS
  • Back
    Aleph

     

    Ex Libris Knowledge Center
    1. Search site
      Go back to previous article
      1. Sign in
        • Sign in
        • Forgot password
    1. Home
    2. Aleph
    3. Knowledge Articles
    4. Copying staff privileges from Prod to Test

    Copying staff privileges from Prod to Test

    1. Last updated
    2. Save as PDF
    3. Share
      1. Share
      2. Tweet
      3. Share
    1. Description
    2. Resolution

     

    • Product: Aleph
    • Product Version: 20, 21, 22, 23
    • Relevant for Installation Type: Dedicated-Direct, Direct, Local, Total Care

     

    Description

    Is there a procedure to copy the staff privileges from PROD to TEST? 

    Resolution

    The Aleph file-03 and file-04 Services can be used to do this.  The staff privileges are in the z67 table.  The z67 contains the z67_user_name, which needs to be in synch with the z66_user_name.  The z66 and z67 tables are in the $pw_library and can be backed up from Production using the file-03 Service, connected to the $pw_library, and loaded onto the Test server via the file-04 Service.

    If your $pw_library is different than your ADM library, you may not be set up to run GUI Services in your $pw_library.  In that case the file-03 can be run from the Unix command line as follows:

    > csh -f $aleph_proc/p_file_03 XXXNN,z66,go > & $alephe_scratch/p_file_03.z66.log &   
    > csh -f $aleph_proc/p_file_03 XXXNN,z67,go > & $alephe_scratch/p_file_03.z67.log &   

    and, to import it on Test with file-04:

    > csh -f $aleph_proc/p_file_04 XXXNN,z66,run > & $alephe_scratch/p_file_04.z66.log & 
    > csh -f $aleph_proc/p_file_04 XXXNN,z67,run > & $alephe_scratch/p_file_04.z67.log & 

    <where "XXXNN" is the $pw_library>

    It should be noted that the z67 has a z67_sub_library column.  And that, therefore, the $alephe_tab/tab_sub_library.lng table on Test needs to be synchronized with that on Production.

     


    • Article last edited: 21-Apr-2018
    View article in the Exlibris Knowledge Center
    1. Back to top
      • Copying Serial Prediction Patterns from ADM to HOL
      • Copyright cleared requests to the British Library
    • Was this article helpful?

    Recommended articles

    1. Article type
      Topic
      Language
      English
      Product
      Aleph
    2. Tags
      1. contype:kba
      2. Prod:Aleph
    1. © Copyright 2025 Ex Libris Knowledge Center
    2. Powered by CXone Expert ®
    • Term of Use
    • Privacy Policy
    • Contact Us
    2025 Ex Libris. All rights reserved