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
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