Add a new Gen Host Encyclopedia administrator using SQL

Products

• Gen - Host Encyclopedia
• Gen

Issue/Introduction

How to appoint another user as an administrator without the intervention of the sole encyclopedia administrator registered in this partition.
For example, the administrator is on vacation or out for an extended period of time.

 

Environment

Gen 8.6 Host Encyclopedia.

Resolution

Under normal use when adding a new user or modifying an existing user only an existing encyclopedia administrator has visibility of the "Encyclopedia Administrator" option (doc. page: Gen™ 8.6 > Encyclopedia > Host Encyclopedia > Using the Host Encyclopedia > User Access Control Tasks > Maintain User Definitions)

However, it is possible to enable an HE user to have "Encyclopedia Administrator" authority by running SQL on that user's row in the HE DUSR table so that the value of column U_USER_TYPE='E'. See: Gen™ 8.6 > Encyclopedia > Host Encyclopedia > Host Encyclopedia Reference > HE DATA TABLES
This will require DB2ADMIN authority.

PLEASE NOTE: Before applying any update SQL please ensure you have a current HE database backup.
In what follows there are also initial SELECT statements to return the current DUSR table contents.

1. To add a new HE user and at the same time make them an "Encyclopedia Administrator" the example SQL would be:
===               
SELECT * FROM DUSR;                            
INSERT INTO DUSR (U_USER_ID, U_USER_NAME, U_USER_TYPE, U_CR_TIME, U_CR_DATE,  U_CR_USER, U_ADD_AUTH) 
VALUES ('USERID', 'FIRSTNAME LASTNAME', 'E',  81358484, 230228, 'CREATION_USERID', 'Y');  
COMMIT;  
===
Where the VALUE fields listed above are per the above doc. page: Gen™ 8.6 > Encyclopedia > Host Encyclopedia > Host Encyclopedia Reference > HE DATA TABLES
NOTES:
With U_USER_TYPE='E' it overrides all other authorities and it does not matter if U_ADD_AUTH='Y' or 'N'.
The U_CR_TIME and U_CR_DATE are stored as integers. U_CR_TIME can be anything and U_CR_DATE is in the format YYMMDD.

2. To update an existing HE user (USERID) and make them an "Encyclopedia Administrator" the SQL would be:
===  
SELECT * FROM DUSR;      
UPDATE DUSR SET U_USER_TYPE='E' WHERE U_USER_ID='USERID';
COMMIT;
===