Skip to main content
  • Subscribe by RSS
  • Ex Libris Knowledge Center

    Copying staff privileges from Prod to Test


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



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


    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
    • Was this article helpful?