Copying staff privileges from Prod to Test

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